very hidden worksheets

[kadamishwar]

i want to hide some of the sheets of workbook.
im doing it manually by using alt+f11 & then properties window option of visible. is it possible with the code?

 

[Richard Schollar]

Hi

Visible property of the worksheet object gives you this option:

Worksheets("Some Sheet").Visible = xlSheetVeryHidden

 

[kadamishwar]

yes it works fine
please tell me the code to make it visible again

 

[Richard Schollar]

Just set the property to

xlSheetVisible

 

[kadamishwar]

thanks