View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Different passwords for each tab in workbook

This kind of Worksheet/workbook protection can be broken very easily. If you
have information that you don't want others to see, don't put it in excel.

If you have to use excel, then don't share the workbook with others.



deidra wrote:

I am looking to do this same task. I want to distrubute a workbook to several
employees. I don't want them to be snooping around at the other tabs. I just
want each person to be able to open the file, click on their tab, type in
their password, and see their information. Can you do this, or does it have
to be done to the entire workbook? i want them to be able to edit their sheet
though.

"Pasko1" wrote:

Can I set different tabs in a workbook to have a different password. I'd
like to be able to distribute a single workbook to a group of sales reps and
I don't want them to see each other's information.


--

Dave Peterson