two "ThisWorkbooks"

S

salgud

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?
 
P

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top