Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet that is hidden. Whenever the checkmark
is clicked, which would result in F12="TRUE", then I want it to open this other sheet called "Polymerase". However, the sheet is protected w/ a password, and I do not want it to prompt the user w/ the password. I have the following code so far: If Worksheets("Instructions").Range("F12") = True Then Sheets("Polymerase").unprotect password:="INGRAM" Sheets("Polymerase").Visible = True Sheets("Polymerase").Select Else Sheets("Polymerase").Visible = False End If And I get a " Run-time error '1004' Unable to set the Visible property of the Worksheet class. " Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Re-post: Code to make sheet very hidden based on date | Excel Discussion (Misc queries) | |||
Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
how to Unprotect sheet | Excel Discussion (Misc queries) | |||
Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions |