Hi all experts -

I am using Excel 2007 VBA and have written a macro which i want to auto
start when Excel is started. I know this can be done but I cannot find the
option to do this. In good english could someone tell me where this is please
as I suspect it is just a setting in the properties panal or similar.

Thanks in advance if you help
--
C Ward

Private Sub Workbook_Open()
'your code here
End Sub

This is workbook event code.
Go into the VBIDE - ALt-F11
Select the VBAProject for your workbook
Make sure that the Microsoft Excel Objects list is expanded
Select Thisworkbookf rom the list
Paste the code in the code window.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"christopher ward" <(E-Mail Removed)> wrote in
message news:489BE33A-BE4F-433E-AA8A-(E-Mail Removed)...
> Hi all experts -
>
> I am using Excel 2007 VBA and have written a macro which i want to auto
> start when Excel is started. I know this can be done but I cannot find the
> option to do this. In good english could someone tell me where this is
> please
> as I suspect it is just a setting in the properties panal or similar.
>
> Thanks in advance if you help
> --
> C Ward

Creating a Worksheet OnOpen Event by double clicking the ThisWorkbook object
in Microsoft Excel Objects, then, selecting the =Open event from the right
hand dropdown, create a new Open event, then paste your macro code into it.

Regards
Dylan

"christopher ward" wrote:

> Hi all experts -
>
> I am using Excel 2007 VBA and have written a macro which i want to auto
> start when Excel is started. I know this can be done but I cannot find the
> option to do this. In good english could someone tell me where this is please
> as I suspect it is just a setting in the properties panal or similar.
>
> Thanks in advance if you help
> --
> C Ward