Run a sub or function on program start?

  • Thread starter Thread starter RASelkirk
  • Start date Start date
R

RASelkirk

I used to know how to do this, but that was a few years ago... What'
the trick to running a VBA sub whenever the workbook is opene
(startup), say for example:

Sub Runme()

msgbox "I'm running"

End Su
 
Hi
einther put your code in the workbook_open event of your workbook
module or name your sub auto_open()
 

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

Ontime run at a particular time 1
Calling subroutine defined in another workbook (autostart workbook) 5
How to call module function or sub from the Add In? 3
Re: VBA Runs After Application.Quit 11
automatically trying to run a macro at a certain time 0
automatically trying to run a macro at a certain time 1
Run code from another workbook 7
Run or Call a sub from the list of subs in a drop down. 8

Back
Top