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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

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