autoload VBA

[-_-\]

How to make the VBA autoload when I open the excel file?
thx a lot~~~

 

[Harald Staff]

Put this in a standard module:

Sub Auto_open()
MsgBox "VBA greets you, earthling"
End Sub

HTH. Best wishes Harald

 

[-_-\]

done~
thx a lot~

Put this in a standard module:

Sub Auto_open()
MsgBox "VBA greets you, earthling"
End Sub

HTH. Best wishes Harald

 

[Harald Staff]

Ur wlcm

 

[George Nicholson]

LOL