Tab View Password Protected

Hi, Can I set different passwords for every tabs in a single worksheet? I mean to view the information of respective tab require a password. So who has password could see the information.

Thank You
Roman

yes - you can
You might want to hide the passwords in a Macro so you can remember

It will be great if we could do it normally. I do not want to use macro. 5/6 will open this spreadsheet. They will use the tab which has thier name with password. So one could not see others information.

NOt a macro to use for a function but

Please Login or Register  to view this content.

Or you could set up a user form that will show you a Paswword when you need it

If you password protect the VB Project - then you will always have the passwords with the doc, you only have to remember the Pw for the VB project
Because a couple of days in a user will forget their password

All you have to do is go to each tab and set the password - the hard part will be remembering all of the PW's