Excel Worksheet protection from viewing


S

Sungibungi

Is there any way I can set a password for one excel sheet--not the workbook
but a specific worksheet--so that only people with the password can view it?

Thanks so much in advance for the help.
 
Ad

Advertisements

G

Gord Dibben

You can hide that one sheet then protect the workbook under
Tools>Protection>Protect Workbook.

Enter a password.

Be aware the Excel's internal sheet and book security is very weak and
passwords easily broken.

A little stronger would be to use VBA code to make the sheet xlveryhidden
then lock the VBA project from view.

Some esoteric shortcut key combo would make the sheet visible via code.

These passwords are harder to crack.....not much<g>

If you don't want people to see something in a workbook, don't include it in
the workbook.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top