Show & hide Sheets - depending on true/false message input.
Posted by Phil on June 27, 2001 1:58 AM
I have a shared work book that is accessed by every1 in the company... However only one sheet is relivant to 99% of them. So what i would like to do is create a macro that has a msg box popup on open and asks them to type in their password if they type in the word other than "password" i want it to hide all the sheets apart from one called "DRUMS". If they type in the word "password" i would like it to show all the sheets.
Any1 know how that could be done...????