two "ThisWorkbooks"
We just upgraded to OfficeXP. In an old spreadsheet, it now has two
"ThisWorkbooks" (ok, one "ThisWorkbook" and a "ThisWorkbook1". They have different icons. ThisWorkbook has the standard XL icon, ThisWorkbook1 has the multicolored icon. ThisWorkbook1 is blank. What is it for? Can I delete it? |
two "ThisWorkbooks"
Maybe 'Thisworkbook1' is a normal or class (withevents wb?) module that
someone has inserted and named, though it should be pretty obvious. But if its under the tree 'Microsoft Excel Objects' try the following - Sub a() MsgBox TypeName(Me) End Sub Regards, Peter T "salgud" wrote in message ... We just upgraded to OfficeXP. In an old spreadsheet, it now has two "ThisWorkbooks" (ok, one "ThisWorkbook" and a "ThisWorkbook1". They have different icons. ThisWorkbook has the standard XL icon, ThisWorkbook1 has the multicolored icon. ThisWorkbook1 is blank. What is it for? Can I delete it? |
All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com