StaceyO
07-28-2011, 10:06 AM
Hello,
I used the code from this site to hide a worksheet from certain users which can only be accessed with a password: (kb/getarticle.php?kb_id=380)
It works great but now I'd like to know if there is a macro that can disable that password and unhide the sheet permanently when the workbook is closed. For my purposes, once the workbook is assigned back to me, I don't need to hide the sheet anymore once it's been accessed. Is this possible?
Thanks in advance and of course, if this question has been answered elsewhere on this forum, please let me know where I can go!
Best,
Stacey
I used the code from this site to hide a worksheet from certain users which can only be accessed with a password: (kb/getarticle.php?kb_id=380)
It works great but now I'd like to know if there is a macro that can disable that password and unhide the sheet permanently when the workbook is closed. For my purposes, once the workbook is assigned back to me, I don't need to hide the sheet anymore once it's been accessed. Is this possible?
Thanks in advance and of course, if this question has been answered elsewhere on this forum, please let me know where I can go!
Best,
Stacey