Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was just running some code I recorded and my worksheet disappeared. The
file is still open and I can see the sheet in my tree view in my VB Editor. But when I am in Excel, the sheet is gone and I am staring at blank page. I think the line of code was: ActiveWindow = False What does this do and how do I get visibility of my sheet back? Thanks EM |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I went to Window/Unhide and it magically came back. Yikes! Didn't know you
could do that. EM "ExcelMonkey" wrote: I was just running some code I recorded and my worksheet disappeared. The file is still open and I can see the sheet in my tree view in my VB Editor. But when I am in Excel, the sheet is gone and I am staring at blank page. I think the line of code was: ActiveWindow = False What does this do and how do I get visibility of my sheet back? Thanks EM |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Go to the Window menu and choose Unhide. You should see your
workbook there. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ExcelMonkey" wrote in message ... I was just running some code I recorded and my worksheet disappeared. The file is still open and I can see the sheet in my tree view in my VB Editor. But when I am in Excel, the sheet is gone and I am staring at blank page. I think the line of code was: ActiveWindow = False What does this do and how do I get visibility of my sheet back? Thanks EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I view the top of my worksheet? It disappeared. | Excel Discussion (Misc queries) | |||
Worksheet disappeared | New Users to Excel | |||
Help: Pictures Disappeared in Excel Worksheet | Excel Discussion (Misc queries) | |||
Worksheet has disappeared | Excel Discussion (Misc queries) | |||
My worksheet menu bar has disappeared? | Excel Worksheet Functions |