Spreadsheet object in VBE appears with the ThisWorkbook icon

[jayray]

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!

 

[jayray]

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!

Here is the workaround (I am the original poster)..

There are 2 other posts on this subject that I have found elsewhere on
the web, and none contains any answers. I just called the Microsoft
support line through the Premier Consulting service that my office
has. The person I talked to has not specific answers to why this
happened, but suggested a workaround of 1) copying all worksheets
(make sure they are all visible first) to a new book, and then 2)
copying any forms and modules in the VBE over to the new workbook. The
forms and modules can be dragged and dropped into the new workbook, so
it is a fairly simple action.

I tried this and it seems to work; the duplicate ThisWorkbook icons
objects have disappeared. (The file I am using is nearly 2 meg and has
45 worksheets.) It is not the best answer--I still don't know what
cause the duplicate icons tto appear to begin with, and neither did
the Microsoft person--but at least the immediate issue is resolved.