auto_open()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wrote a macro with the sub Auto_Open(). This macro is supposed to run
automatically when I open excel workbook (double-click existing workbook file
to open), but it is not running? I can run it after I open the book, which
shows the macro works w/o errors. Can someone point me to docs or offer a
solution?
 
Where would I check that? I can see the event from a program, but I don't
know how to use it when I am manually opening the workbook. Should it be
included in my macro as a sort of post-open debugging tool?
 
You didn't put it in the ThisWorkbook module by any chance? It should be in
a standard module (Insert, Module).
 
Sounds like you have put the code in ThisWorbook, instead of a normal code
module. Check this by right clicking on the Excel icon on the worksheet (or
next to the File menu if you maximise your workbooks), select View Code from
the menu, and paste the code.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Actually, this is my first macro. In the VB Editor from Excel, I don't see it
in the Project-VBAProject/Mocrosoft Excel Objects list. I added it as an
insert/module and that corrected my problem.

Thanks,
Rick
 

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
Shift key doesn't stop Auto_Open() from firing 1
with a macro open a workbook without the Auto_Open running 3
Auto_Open from Outlook 2
Automatically changing default formatting upon opening new workbook 2
Excel 2013 menubar incompatibility? 1
trying to replace auto_open with something like workbook_open 1

Back
Top