Macro to sheet to very hidden

[sureshpunna]

Dear all,

i'm new to vba what is wrong in below code.
please help.

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+y
If sheetactive.visuble = True Then
sheetactive.visuble = xlVeryHidden
Else
sheetactive.visuble = xlVeryHidden
End If

End Sub

[coreytroy]

Please Login or Register  to view this content.

[HaHoBe]

Hi, sureshpunna,

normally I would expect any other action than to hide the sheet if it is already very hidden. BTW: isnīt the command xlSheetVeryHidden?

Ciao,
Holger

[sureshpunna]

Thank you for quick response helped me lot