PDA

View Full Version : Running a macro when excel startsup



sls
09-25-2007, 07:16 AM
hallo,

Is it possible to run a macro when excel starts up?

example:
you klik on the file
the file open
a macro starts running
the new information is in the sheet visible for the user.

kind regards,

sls

JKwan
09-25-2007, 07:31 AM
Add a module and have a sub call AUTO_OPEN

Sub auto_open()
MsgBox "test"
End Sub

OR
put into workbook open event

Private Sub Workbook_Open()
MsgBox "test"
End Sub

sls
09-25-2007, 07:39 AM
thank u, I have been searching, and now that i see it, it is so simple.

thank u.