Workbook there but not visible! Help!

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

I was working on some VBA code for an excel application I
am writing. I switched between the VBE and the
spreadsheet and all of a sudden my workbook is no longer
visible! In the VBE project explorer window it shows my
project and my code but in the excel window...no
workbook! Nothing!

Ran a test procedure calling IsAddin to see if somehow I
accidentally clicked a button/box telling Excel to make
this file an addin but it returned false.

I did close the file and re-open it.

Any ideas?
 
Maybe it's just off the visible screen:
Window|Arrange|tiled (and resize manually)

or maybe you hid it
window|unhide

Or maybe you did make it an addin.
Inside the VBE, hit ctrl-G (to see the immediate window)
type this and hit enter:
workbooks("yourworkbookname.xls").isaddin = false

(You can get to this property by hitting ctrl-R (still in the VBE). Clicking on
the ThisWorkbook object and then hitting F4 (to view the properties).
 
Back
Top