![]() |
Worksheet just disappeared
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 |
Worksheet just disappeared
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 |
Worksheet just disappeared
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 |
All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com