Worksheets with password protection

J

Judy Bryant

I am wanting to create a workbook with several worksheet tabs. Each tab
represents different depts. When I send this workbook out to different
depts., I do not want the other depts. to see the other tabs that do not
pertain to them.

Can I hide with a password the individual worksheets within that workbook?
Please advise how to do that.
 
D

Dave F

Excel passwords are not secure and can be broken easily. If you have
confidential information that someone should not see, best practice is to not
include that info in your workbook.
 
V

Vijay_India

Its not possible to create different passwords to different sheets within an
excel file.

To circumvent this problem, the option which I see is to split the excel
file into master and individual department files rather than having all of
them in one single excel file.

Hope this arrangement help you. I dont see any other alternative.

Thanks,
 
Top