unprotect sheet in code and make sheet visible

P

peach255

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!
 
D

Dave Peterson

Are you running xl97?

Is your code associated with a checkbox from the controltoolbox toolbar?
If yes, then try adding:
activecell.activate
to the top of your code.

If it's run from a control from the control toolbox toolbar that has a
takefocusonclick property, you can change that to False.

(It's a bug that was fixed in xl2k.)

If none of this was true, then post back with your version of excel, where the
code is located, and how it's called.
 
Top