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

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