ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet just disappeared (https://www.excelbanter.com/excel-programming/364571-worksheet-just-disappeared.html)

ExcelMonkey

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

ExcelMonkey

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


Chip Pearson

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