How do I password protect hidden sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Sheet protection 6
2003/2007 Compatibility Issue - Hidden Sheets 4
password protect a sheet 5
I forget the password of protecting sheet, I need to unprotect it 1
Password Protect a Sheet 1
How to keep hidden columns hidden using protection 1
password protect unhide sheet command 1

Back
Top