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

--
RASelkir
-----------------------------------------------------------------------
RASelkirk's Profile: http://www.excelforum.com/member.php...fo&userid=1621
View this thread: http://www.excelforum.com/showthread.php?threadid=27804

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

Sub auto_open()
Call MyProgram
End Sub

Glen

"RASelkirk" wrote in message
...

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


--
RASelkirk
------------------------------------------------------------------------
RASelkirk's Profile:
http://www.excelforum.com/member.php...o&userid=16216
View this thread: http://www.excelforum.com/showthread...hreadid=278044