View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jayray jayray is offline
external usenet poster
 
Posts: 45
Default Spreadsheet object in VBE appears with the ThisWorkbook icon

I have a model with mutliple worksheet. In the VBE, each worksheet is
shown in the VBAProject window in the upper left hand corner of the
screen. Each worksheet object has the icon that looks like a grid of
tables with a paper icon behind it (the "grid icon"). The ThisWorkbook
object appears normally, which is to say, its icon is a green XL
symbol over the paper icon (I'll call this second type the "XL icon")

What is strange is that I have one other worksheet object called
DevNotes which appears as both a Grid icon and an XL icon. I have had
to rename the "regular" one and change the macro accordingly.

When I click on the XL icon of DevNotes, the properties that shows up
in the Properties windows shows the (Name) as "This Workbook"!

Even if I delete the worksheet itself and then go back to the VBE, the
Grid icon for that worksheet has disappeared, but the "XL" icon is
still there.

Has anybody come across this situation and is there a way to clean up
the model? The model is going to be used by upwards of 100 people, so
I to address all the strange quirky things before it goes ut.

Thanks!