How do I password protect hidden sheet?

G

Guest

Hi Everyone,

I have Excel 2000 and I want to make it were I can hide a sheet and password
protect it so when someone else tries to unhide the sheet it will prompt them
for the password before it unhides. I have looked at the protection options
and I couldn't find it.

Thanks
Mascot
 
J

Jim Rech

Excel does not have the feature you want. The best you can do is hide the
sheet and then set workbook protection using Tools, Protection, Protect
Workbook. A user would have to unprotect the workbook before he could even
open the Unhide sheet dialog.

--
Jim
| Hi Everyone,
|
| I have Excel 2000 and I want to make it were I can hide a sheet and
password
| protect it so when someone else tries to unhide the sheet it will prompt
them
| for the password before it unhides. I have looked at the protection
options
| and I couldn't find it.
|
| Thanks
| Mascot
 

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

hide, unhide column or row after protect worksheet 4
Password Protect a Sheet 1
Sheet protection 6
Must I use IRM to protect an entire workbook? 1
password protect a sheet 5
Password Protect Sheet with formatting allowed 3
How to keep hidden columns hidden using protection 1
how do i recover a forgotten password in excel? 1

Top