xlveryhidden macro runtime error 438 object doesn't support property or method

Davavo

Board Regular
Joined
Aug 3, 2019
Messages
82
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 :-(

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
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Hi & welcome to MrExcel.
You've misspelt Visible
 
Upvote 0
You're welcome & thanks for the feedback.

The only stupid question is the one you don't ask.;)
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,241
Members
452,622
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top