Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spreadsheet object in VBE appears with the ThisWorkbook icon
On Sep 16, 3:07*pm, jayray wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change label of an embedded-object icon | Excel Discussion (Misc queries) | |||
Hlp - Display only file name when Insert Object As Icon | Excel Programming | |||
Line appears - not border, not object, does not print - what is it | Excel Discussion (Misc queries) | |||
Detecting if OLE object is displayed as an icon | Excel Programming | |||
Toggling Display as Icon for OLE Object | Excel Programming |