Can I hide a worksheet and set a passwd to unhide it?


Puneet Arora


--
puneetarora_12
------------------------------------------------------------------------
puneetarora_12's Profile: http://www.excelforum.com/member.php...o&userid=18406
View this thread: http://www.excelforum.com/showthread...hreadid=389664

you can hide a sheet on the format sheet menu.Dont know about the password
thng tho sorry
--
paul
remove nospam for email addy!



"puneetarora_12" wrote:


Can I hide a worksheet and set a passwd to unhide it?


Puneet Arora


--
puneetarora_12
------------------------------------------------------------------------
puneetarora_12's Profile: http://www.excelforum.com/member.php...o&userid=18406
View this thread: http://www.excelforum.com/showthread...hreadid=389664

You can hide a worksheet, even hide it from the Format/Worksheet/Unhide
dialog (by setting the sheet's .Visible property to xlVeryHidden), and
then use macros to unhide and rehide it. The project would have to be
secured with a VBA password.

However, this is not particularly secure, as VBA passwords can be broken
easily.

In article
<puneetarora_12.1snr6a_1122181503.1504@excelforu m-nospam.com,
puneetarora_12
<puneetarora_12.1snr6a_1122181503.1504@excelforu m-nospam.com wrote:

Can I hide a worksheet and set a passwd to unhide it?