Autorun a macro

Thanks Andy,
Sound simple, but most of that went straight over my head, so it's back
to the old VB help now to see what you're talking about.
Paul

*** Sent via Developersdex http://www.developersdex.com ***

Good afternoon Paul Wisken

Two ways:

First call your macro Auto_Open eg:
Sub Auto_Open()

Second, the above will work but you should really use the event procedures facility. Put the code for your macro in the ThisWorkbook pane within the VBE, rather than the Modules pane and then change the name to Workbook_Open().

Does that make any more sense...?

For more information about this have a look here:

http://www.cpearson.com/excel/events.htm

HTH

DominicB

Thanks everyone.
It's now working perfectly

Paul

*** Sent via Developersdex http://www.developersdex.com ***