Can anyone tell me how to auto run a macro as soon as you open
a sheet/workbook (excel 2000, win2000)

Thanks

Sap

--

Put this in thethis workbook code

Private Sub Workbook_Open()
'your code here
End Sub


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"jee22" <(E-Mail Removed)> wrote in message
news:bmocem$688$(E-Mail Removed)...
> Can anyone tell me how to auto run a macro as soon as you open
> a sheet/workbook (excel 2000, win2000)
>
> Thanks
>
> Sap
>
> --
>
>
>
>

Thank you, I tried that and it did not work
"Paul B" <(E-Mail Removed)> wrote in message
news:uxo6$(E-Mail Removed)...
> Put this in thethis workbook code
>
> Private Sub Workbook_Open()
> 'your code here
> End Sub
>
>
> --
> Paul B
> Always backup your data before trying something new
> Using Excel 2000 & 97
> Please post any response to the newsgroups so others can benefit from it
> ** remove news from my email address to reply by email **
> "jee22" <(E-Mail Removed)> wrote in message
> news:bmocem$688$(E-Mail Removed)...
> > Can anyone tell me how to auto run a macro as soon as you open
> > a sheet/workbook (excel 2000, win2000)
> >
> > Thanks
> >
> > Sap
> >
> > --
> >
> >
> >
> >
>
>

You may have to change the macro security settings to get the macro to run.
Tools, macros, security

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"jee22" <(E-Mail Removed)> wrote in message
news:bmvuk3$br2$(E-Mail Removed)...
> Thank you, I tried that and it did not work
> "Paul B" <(E-Mail Removed)> wrote in message
> news:uxo6$(E-Mail Removed)...
> > Put this in thethis workbook code
> >
> > Private Sub Workbook_Open()
> > 'your code here
> > End Sub
> >
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Using Excel 2000 & 97
> > Please post any response to the newsgroups so others can benefit from it
> > ** remove news from my email address to reply by email **
> > "jee22" <(E-Mail Removed)> wrote in message
> > news:bmocem$688$(E-Mail Removed)...
> > > Can anyone tell me how to auto run a macro as soon as you open
> > > a sheet/workbook (excel 2000, win2000)
> > >
> > > Thanks
> > >
> > > Sap
> > >
> > > --
> > >
> > >
> > >
> > >
> >
> >
>
>

Thanks Paul ... I got there in the end .... very grateful


"Paul B" <(E-Mail Removed)> wrote in message
news:uf$(E-Mail Removed)...
> You may have to change the macro security settings to get the macro to
run.
> Tools, macros, security
>
> --
> Paul B
> Always backup your data before trying something new
> Using Excel 2000 & 97
> Please post any response to the newsgroups so others can benefit from it
> ** remove news from my email address to reply by email **
> "jee22" <(E-Mail Removed)> wrote in message
> news:bmvuk3$br2$(E-Mail Removed)...
> > Thank you, I tried that and it did not work
> > "Paul B" <(E-Mail Removed)> wrote in message
> > news:uxo6$(E-Mail Removed)...
> > > Put this in thethis workbook code
> > >
> > > Private Sub Workbook_Open()
> > > 'your code here
> > > End Sub
> > >
> > >
> > > --
> > > Paul B
> > > Always backup your data before trying something new
> > > Using Excel 2000 & 97
> > > Please post any response to the newsgroups so others can benefit from
it
> > > ** remove news from my email address to reply by email **
> > > "jee22" <(E-Mail Removed)> wrote in message
> > > news:bmocem$688$(E-Mail Removed)...
> > > > Can anyone tell me how to auto run a macro as soon as you open
> > > > a sheet/workbook (excel 2000, win2000)
> > > >
> > > > Thanks
> > > >
> > > > Sap
> > > >
> > > > --
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>