Running Macros when opening Excel

Is it possible to set up a macro that automatically runs when you open excel?

Thanks

If you mean when you open an existing workbook try putting your code in:

Private Sub Workbook_Open()

End Sub


"Neil Hopkinson" wrote:

> Is it possible to set up a macro that automatically runs when you open excel?
>
> Thanks

that's exactly what I mean, thanks

"Charlie" wrote:

> If you mean when you open an existing workbook try putting your code in:
>
> Private Sub Workbook_Open()
>
> End Sub
>
>
> "Neil Hopkinson" wrote:
>
> > Is it possible to set up a macro that automatically runs when you open excel?
> >
> > Thanks

it doesn't seem to work though, any more ideas?

"Neil Hopkinson" wrote:

> that's exactly what I mean, thanks
>
> "Charlie" wrote:
>
> > If you mean when you open an existing workbook try putting your code in:
> >
> > Private Sub Workbook_Open()
> >
> > End Sub
> >
> >
> > "Neil Hopkinson" wrote:
> >
> > > Is it possible to set up a macro that automatically runs when you open excel?
> > >
> > > Thanks

the question was when you open excel...

so you must open a file first that has a workbooK_open eventhandler.

that can be: any activated addin.
any file in the xlstart folder
any file in the folder listed under:
tools/options/General
"at startup, open ALL files in"


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Neil Hopkinson wrote :

> it doesn't seem to work though, any more ideas?
>
> "Neil Hopkinson" wrote:
>
> > that's exactly what I mean, thanks
> >
> > "Charlie" wrote:
> >
> > > If you mean when you open an existing workbook try putting your
> > > code in:
> > >
> > > Private Sub Workbook_Open()
> > >
> > > End Sub
> > >
> > >
> > > "Neil Hopkinson" wrote:
> > >
> > > > Is it possible to set up a macro that automatically runs when
> > > > you open excel?
> > > >
> > > > Thanks

Where did you put the Workbook_Open event? It must go in the
ThisWorkbook code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Neil Hopkinson" <[email protected]> wrote
in message
news:[email protected]...
> it doesn't seem to work though, any more ideas?
>
> "Neil Hopkinson" wrote:
>
>> that's exactly what I mean, thanks
>>
>> "Charlie" wrote:
>>
>> > If you mean when you open an existing workbook try putting
>> > your code in:
>> >
>> > Private Sub Workbook_Open()
>> >
>> > End Sub
>> >
>> >
>> > "Neil Hopkinson" wrote:
>> >
>> > > Is it possible to set up a macro that automatically runs
>> > > when you open excel?
>> > >
>> > > Thanks

I didn't put it in the ThisWorkbook code to start with, I have now though and
it seems to be working

Thanks for your help

"Chip Pearson" wrote:

> Where did you put the Workbook_Open event? It must go in the
> ThisWorkbook code module.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Neil Hopkinson" <[email protected]> wrote
> in message
> news:[email protected]...
> > it doesn't seem to work though, any more ideas?
> >
> > "Neil Hopkinson" wrote:
> >
> >> that's exactly what I mean, thanks
> >>
> >> "Charlie" wrote:
> >>
> >> > If you mean when you open an existing workbook try putting
> >> > your code in:
> >> >
> >> > Private Sub Workbook_Open()
> >> >
> >> > End Sub
> >> >
> >> >
> >> > "Neil Hopkinson" wrote:
> >> >
> >> > > Is it possible to set up a macro that automatically runs
> >> > > when you open excel?
> >> > >
> >> > > Thanks
>
>
>