View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bowtie63 Bowtie63 is offline
external usenet poster
 
Posts: 19
Default How do I make Excel display a specific worksheet?

I have a workbook with a few worksheets, one sheet per person in my group.
Can I set up Excel so that when an individual opens the workbook, they can
see only their own specific worksheet without seeing the others? Or is there
a way that I can create a query that asks the user to select from a list and
enter a password to bring up a specific sheet? Thank you in advance for your
help!