Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mysterious auto_open
Hi All,
I have a file that runs a CopyAll macro when it is opened. I can view the CopyAll macro in the vb editor.The funny thing is there is no auto_open macro (or workbook_open) when i was in the editor. I was puzzled why the macro will be executed automatically even without these two macros. I found that there is a auto_open macro in atpvbaen.xls which will call auto_open macro when i run it. But i can't view the addin since it has a password. This is completely baffling. Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mysterious auto_open
I assume that when you say there is no Workbook_Open that you checked the
ThisWorkbook code module, and that you checked the sheets code modules to see if there was a Worksheet_Change or Worksheet_Activate code. If you did all that, then it is truly a mystery. " wrote: Hi All, I have a file that runs a CopyAll macro when it is opened. I can view the CopyAll macro in the vb editor.The funny thing is there is no auto_open macro (or workbook_open) when i was in the editor. I was puzzled why the macro will be executed automatically even without these two macros. I found that there is a auto_open macro in atpvbaen.xls which will call auto_open macro when i run it. But i can't view the addin since it has a password. This is completely baffling. Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mysterious number | Charts and Charting in Excel | |||
Mysterious change to #REF | Links and Linking in Excel | |||
Mysterious formatting - cannot fix | Excel Worksheet Functions | |||
Mysterious link | Excel Discussion (Misc queries) | |||
Mysterious button | Excel Programming |