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