hi, if anyone could explain why this is happening i would be very grateful
I have a hidden sheet 'Exp' that is password protected, and automatically hides (veryhidden) when the user navigates away from it.
This all works fine.
The incorrect password message works too.
But I am getting this run-time error if the password is entered correctly.
I cant figure it out
I have tried removing the auto hide thing, i have tried unprotecting it first. All seems to be irrelevant,
Is the syntax wrong?
Thanks in advance
I have a hidden sheet 'Exp' that is password protected, and automatically hides (veryhidden) when the user navigates away from it.
This all works fine.
The incorrect password message works too.
But I am getting this run-time error if the password is entered correctly.
I cant figure it out
Code:
Sub Hide_Exp(X As Boolean)
If X = True Then
Sheets("Exp").Visable = xlVeryHidden
Else
Sheets("Exp").Visable = True
Worksheets("Exp").Activate
End If
End Sub
I have tried removing the auto hide thing, i have tried unprotecting it first. All seems to be irrelevant,
Is the syntax wrong?
Thanks in advance