Protecting Sheet

[agnerc]

Is there a way to protect a sheet from being viewed until a password is entered unless someone has another idea?

The reason I ask is because I am wanting to have tabs for specific vendors and I do not want vendors seeing each others information.

Thank you,

 

[footoo]

https://www.mrexcel.com/forum/excel-questions/1064692-can-worksheets-password-protected-viewing.html

 

[Jaafar Tribak]

Is there a way to protect a sheet from being viewed until a password is entered unless someone has another idea?

The reason I ask is because I am wanting to have tabs for specific vendors and I do not want vendors seeing each others information.

Thank you,

You can have the Workbook Structure password-protected with all vendors sheets hidden and then use vba code in the workbook open event that asks the user to enter their password for their corresponding sheet before they can unhide the sheet.

Hide the vendors sheets back in the BeforeClose event and reprotect the workbook structure.

You may also want to password protect the VBAProject from viewing.