Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I love this code below, but I dont know how to access the sheet once it is hidden. 1st Question - How do I access it using the password? 2nd Question - Is there anyway that I can set this workbook to reveal the hidden sheet when I use the password to open (not as read only) or is it macro based only? Sub HideModeratelyWell() With Sheets("YourSheetName") .Protect Password:="ThisIsBreakable" .Visible = xlVeryHidden End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
various printing from a hiden sheet | Excel Programming | |||
various printing from a hiden sheet | Excel Programming | |||
various printing from a hiden sheet | Excel Programming | |||
hiden sheet | Excel Programming | |||
code to ask for password to get access to sheet | Excel Programming |