Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Module of VB sets as default on Excel sohraaz Excel Discussion (Misc queries) 1 July 21st 07 02:24 PM
code in module A to not execute a Worksheet_SelectionChange sub of another module Jack Sons Excel Discussion (Misc queries) 4 December 11th 05 11:52 PM
Run worksheet module code from workbook module? keithb Excel Programming 1 August 14th 05 04:04 AM
Default in a textbox and change a module name filo666 Excel Programming 4 April 22nd 05 08:36 PM
Changing Default Module Location Ron Dahl[_2_] Excel Programming 1 October 1st 04 04:13 AM


All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"