Load Macro at start up?

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

Guest

Try this

Sub Auto_Open()

Record macro as normal. Auto_Open will run everytime.
 
not quite true - Auto macros do not automatically run if the
workbook is opened from code.

Instead use the Worksheet_Open() event macro.
 
You must log in or register to reply here.

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
Building Menus with Macros upon opening Excel 2
Bypass Auto_Open 13
Macro to open file bypasses Auto_Open 4
Make macro run on all worksheets except the first 1
File opens another file runs macro and closes 2
Macro to run on Mon and Tues 5
Automatically changing default formatting upon opening new workbook 2

Back
Top