Thread: Macro Button
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scuba scuba is offline
external usenet poster
 
Posts: 8
Default Macro Button

I've created a workbook with some "management eyes only" worksheets but other
sheets need to be seen by all employees. The document opens up to a home
page with macro buttons that when selected go to specific tabs in the
document. When left the tabs are hidden. My question I'm seeking help with
is if there is a way that when a particular macro button is selected, it asks
for a password that must first be entered before going to one of these sheets
that isn't open to everyone. Any ideas.