View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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?