Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |