Lock a sheet

[EtienneD]

Hi guys. Is it possible to lock (or protect) one of the sheet (bottom tab) of my excel file so the reader can only access some tabs but some other would be lock with a password?

Thank you in advance!

 

[6StringJazzer]

Yes, you can protect (lock) individual sheets, and optionally use a password. However, what do you want to prevent? Protecting a sheet will still allow a user to view it, but they can't change any locked cells. If you want to prevent a user from even viewing it you have to take further steps.

 

[EtienneD]

Yes, you can protect (lock) individual sheets, and optionally use a password. However, what do you want to prevent? Protecting a sheet will still allow a user to view it, but they can't change any locked cells. If you want to prevent a user from even viewing it you have to take further steps.

Thanks for the fast reply. Yes excatly, I need to prevent the user from even viewing this particular sheet, but I want it to stay in there since it contains a bunch of codes. I saw I can maybe hide it, but is it possible that when the user click on it, it asks for a password or just refuse access until the document is unprotected?

 

[6StringJazzer]

Hide the sheets you want to hide
Go to Review, Protect Workbook, check "Protect structure"
Provide a password
Click OK

Make sure you do not forget this password!

Users will not be able to unhide the worksheet without the password. They will also not be able to hide, rename, add, or delete worksheets.

 

[EtienneD]

Hide the sheets you want to hide
Go to Review, Protect Workbook, check "Protect structure"
Provide a password
Click OK

Make sure you do not forget this password!

Users will not be able to unhide the worksheet without the password. They will also not be able to hide, rename, add, or delete worksheets.

Thanks for the tip! So execpt for hidding the tab there’s no way to just “lock” the access with a password? Not even with VBA code?

 

[6StringJazzer]

There is no built-in way to have a worksheet tab visible but prevent the user from opening that worksheet.

I think there is a way to do this with VBA where as soon as the restricted sheet is activated by the user, the VBA immediately activates a different sheet. However, if a user wants to access that sheet all they have to do is disable macros. VBA for security is not strong.