MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Alladin, Ivan, anyone! Ive done something stupid..PLEASE help...


Posted by anon on August 16, 2001 11:47 AM

I was trying some new code and I can't see my workbooks anymore.

I had three workbooks open and in the last one I was testing this code:

Sub MeHide()
On Error Resume Next
ActiveWindow.Visible = False
On Error Resume Next
ActiveWindow.Visible = False
On Error Resume Next
ActiveWindow.Visible = False
End Sub

I was trying to make a 'Preview' button for some forms I was making. It was supposed to hide all open forms so the user could see the spreadsheet underneath; like a preview of what they were doing behind the forms. Of course all this did was hide the open workbooks behind the forms. Now I can't get them visible again... I tried saving, exiting, and re-opening the files, but they're still hidden!!! I can see them in the project explorer, but can't access a 'visible' property (or any properties) to reverse what I've done!!! PLEASE HELP!

anon


Posted by Dax on August 16, 2001 11:52 AM

In Excel just open your files, choose Window, Unhide and you should see you hidden workbooks.

Regards,
Dax.

Posted by anon on August 16, 2001 12:14 PM

thanks Dax!!!

Now I feel a little more stupid:-) Maybe I should just stay away from this VBA stuff!

anon