MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Very Unhidden


Posted by Sphinx on November 08, 2001 8:55 AM

I'm a fairly neophyte at VBA but what I am trying to do is record the actions to VeryUnhide a worksheet in the Project window of a workbook. When I use the macro recorder, it doesn't develop any code. Any suggestions on code for making this happen or to record it.

Thanks


Posted by Juan Pablo on November 08, 2001 8:59 AM

You can't record this, have to write it. (NT)

Posted by Sphinx on November 08, 2001 9:06 AM

Re: You can't record this, have to write it. (NT)

Any suggestions on the code would be greatly appreciated,

Posted by Juan Pablo on November 08, 2001 9:11 AM

Re: You can't record this, have to write it. (NT)

Sub VeryHideSheet()
Sheets("Sheet2").Visible = 2
End Sub

Juan Pablo