How do I password protect a single worksheet within a workbook f

G

Gord Dibben

You could hide the worksheet at Format>Sheet>Hide.

Then Tools>Protection>Protect Workbook. Check Structure and Windows.

Supply a password.

Note: Excel internal workbook and worksheet security is quite weak with password
cracking programs aplenty for those determined to view your worksheet.

The general rule is...if you don't want users to see the data, don't include it
in your 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

Similar Threads

Protect and Unprotect all worksheets with macro 2
Password Protect Specific Range Of Cells 6
I need help password protecting a worksheet 9
How to I reset a forgotten Excel worksheet protection password? 3
Protecting more than one worksheet in one workbook 1
password protected worksheet 7
corrupted formula in protected worksheet 21
password protect a sheet 5

Top