Mysterious auto_open

R

rogermht

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto_Open Code on Worksheet 2
Bypass Auto_Open 13
Triggering auto_open 5
Macro to open file bypasses Auto_Open 4
Auto_Open Workbook_Open 4
Auto_Open Macro 5
Addin Auto_Open code executes only in debug mode 2
Change file to read only 3

Top