Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 553
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 553
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I view the top of my worksheet? It disappeared. PDXT Excel Discussion (Misc queries) 1 June 7th 07 12:31 AM
Worksheet disappeared hannahp New Users to Excel 3 April 25th 07 07:16 PM
Help: Pictures Disappeared in Excel Worksheet Steve C. Excel Discussion (Misc queries) 0 December 13th 06 04:13 AM
Worksheet has disappeared frankybenali Excel Discussion (Misc queries) 2 February 1st 06 03:15 PM
My worksheet menu bar has disappeared? YMV74 Excel Worksheet Functions 0 January 3rd 06 07:11 PM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"