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
 
J

JLGWhiz

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

Triggering auto_open 6
Macro Loop 0
Auto_Open Code on Worksheet 2
Need Help with Macro Security 1
Hold shift to stop Auto_Open() not working in 2007 0
Bypass Auto_Open 13
Macro to open file bypasses Auto_Open 4
Auto_open MAcro 1

Top