View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default Sheets - Limited acces

Howdie....
I need only certain sheets to be visible, depending on who is looking.

I looked at the previous submitted query today, but that response doesnt
work for me.

I have Five sheets.
Sheets One to Three (no pun intended :) ) are visible all the time
Sheets Four and Sheet Five only visible to a selective audience.
I would like to write VBA so that when the user runs the macro it asks
for a password, or username, and then if the correct answer is inputted,
it unhides Sheets Four or Five.
Too adventurous?
Other ideas welcomed...

Thanks!!

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!