Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default How do I password protect hidden sheet?

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default How do I password protect hidden sheet?

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
"Mascot" wrote in message
...
| 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using VB to password protect, but sheet remains visible JennyJeneralGraves Excel Discussion (Misc queries) 0 March 30th 06 02:12 AM
Password protect a hidden tab Dominic Excel Discussion (Misc queries) 2 March 23rd 06 09:23 PM
Validate MsgBox Entry to Data in Cells David Excel Discussion (Misc queries) 13 December 21st 05 10:31 PM
How to password protect hidden columns and custom views in Excel blade444 Excel Discussion (Misc queries) 2 July 29th 05 01:36 PM
Auto Protect workbook with password upon opening Brian Excel Worksheet Functions 0 February 23rd 05 05:45 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"