View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Run a sub or function on program start?

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

Sub Runme()

msgbox "I'm running"

End Sub