MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Passwords in macros


Posted by Diana on October 31, 2001 12:25 PM

Hello,

I am trying to make a macro to hide certain tabs in a workbook and then protect the workbook. Then another macro to unprotect workbook and unhide pages. I get the macro to work but it does not prompt a box to enter password, it just automatically protects or unprotects and I need it to prompt for password first. Any suggestions would be helpful.

Thanks!


Posted by diana on October 31, 2001 12:27 PM