ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What was the default name for the Auto_Open() module? (https://www.excelbanter.com/excel-programming/341309-what-default-name-auto_open-module.html)

CRayF

What was the default name for the Auto_Open() module?
 
Before I knew better, I renamed some of my Modules. I have since put them
back to their given name but cannot remember what the Auto_Open() module was
named?

Was it by chance also named: Auto_Open?


Rowan[_9_]

What was the default name for the Auto_Open() module?
 
I'm not too sure what you mean by the Auto_Open module but if you are
talking about the module which holds your
Workbook_Open event then by default it is called ThisWorkbook.

Regards
Rowan

CRayF wrote:
Before I knew better, I renamed some of my Modules. I have since put them
back to their given name but cannot remember what the Auto_Open() module was
named?

Was it by chance also named: Auto_Open?


Dave Peterson

What was the default name for the Auto_Open() module?
 
Don't use the same name for modules and routines--it can confuse excel.

And you should be able to name it anything (else!) you want. Excel will find
it.



CRayF wrote:

Before I knew better, I renamed some of my Modules. I have since put them
back to their given name but cannot remember what the Auto_Open() module was
named?

Was it by chance also named: Auto_Open?


--

Dave Peterson


All times are GMT +1. The time now is 12:33 AM.

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