Hi,
You can do that fairly easily but it does require a few steps:-
1. Prepare you workbook and one way to run the macro automatically is to put
it in the workbook open event like this:-
Private Sub Workbook_Open()
MsgBox "Hello"
End Sub
2. You must now digitally sign the workbook so you don't get the 'Enable
Macros' warning when it opens so in Windows:-
Go to Start>Programs>Microsoft Office>Office Tools and build a cert from
there, it's very simple and intuative.
Once created, open your workbook and go to the VBE and
Tools>Digital Signature>Choose.
Pick the one you just created and OK then Save.
Close workbook and open it again.
Check "always trust this publisher" and enable macros.
Now the last bit and once again in Windows
Start|Settings|Control Panel and select schedule tasks
Once again this is very intuative but the thing to remember on the first
step is brows to you excel workbook and not simply open Excel.
Mike
