Hi,
I have a workbook that has multiple worksheets… for this example, I’ll say it has 10 worksheets in it. I’m wondering if it’s possible to have some of the 10 worksheets automatically hide and password protect themselves based on who the user is opening the file. I’d like to have one file, as opposed to separating out the worksheets 20 ways to Sunday for distribution purposes. Of course it’s not the end of the world if someone “cracks” the password (which I doubt they would even try, as they are not hard core Excel / computer users… likewise they are all internal customers so I’m not too worried). I’m thinking a macro could do it, but what if they say “disable” macros when opening the file? Likewise, I wouldn’t know how to even attempt writing the macro/VBA for this type of action (at least not yet… I’m signed up for some training… finally!!). I did a search and found that someone had code to hide the worksheets, however it’s not exactly what I’m looking for… I’m thinking I’d have a worksheet with each users ID name listed in it and a list of the worksheets each user has access to, and then the macro would do some sort of a vlookup based on the list and unhide and unprotect the listed worksheets for that user?? Any ideas anyone??
Thanks!!
Lana
-
Hide & Password Protect Worksheet Based on User (Excel 2002)
- This topic has 9 replies, 4 voices, and was last updated 16 years, 9 months ago.
AuthorViewing 0 reply threadsAuthorViewing 0 reply threads