ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   two "ThisWorkbooks" (https://www.excelbanter.com/excel-programming/422525-re-two-thisworkbooks.html)

Simon Lloyd[_977_]

two "ThisWorkbooks"
 

ThisWorkbook1 sounds like it was an import of the Thisworkbook.bas (a
file created when you export a module), when you import that file where
one already exists a Class module is created, you can safely delete it
once you have copied any code that may be in it that you want to keep!salgud;183993 Wrote:
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?



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50841



All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com