Thread: protect tab
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andre[_5_] Andre[_5_] is offline
external usenet poster
 
Posts: 11
Default protect tab

I'm building an Excel app that has 2 tabs; user and admin. I would like to
have the admin tab password protected, so that if "user" opens the workbook
and clicks on the "admin" tab, they are prompted for a password. Obviously
this is a way of hiding the Admin tab from those who are not allowed to see
it. Is this possible? If so, how would I go about doing it? Or is there
another solution that is recommended?

Thanks, Andre