Macro for Do Not Unhide Sheets

[hoomantt]

Hi Professors

I have a question.

Is there any way(a macro) that when users want to unhide the hidden sheets , they see a window to input password(password has been made by admin)?

basically i want a macro to hide several sheets that i determine the sheets name.(i think there is better that i determine the sheet names that should be visible for every one and when macro runs other sheets change to hide or very hide)

for example : visible sheets for users are 3 sheets and not visible sheets are 20 sheets)

therefore i wanna a macro to hide the other sheets by 1 of 2 bellow ways :

1- hide sheets with macro and when user want to unhide them should fill the password

2-make sheets very hidden by a macro and a password and visible sheets by fill the password.

can any one help me please!!!!!!!!1

 

[bobhc]

Good day hoomantt


Amazing thing that search box top right


http://chandoo.org/forums/topic/a-macro-for-let-just-users-that-have-a-password-to-unhide-the-hide-sheets


This is just one of many links covering the subject.