|
Can I hide a worksheet and set a passwd to unhide it?
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? |
| All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com