Hi
How do I get macros or some code to run automatically when I start up an
excel worksheet?
Thanks
Hi
How do I get macros or some code to run automatically when I start up an
excel worksheet?
Thanks
I think you mean workbook, not sheet, correct? Open your workbook. Hit
Alt+F11 or Tools-->Macro-->Visual Basic Editor. Double-click ThisWorkbook on
the left below your Project's name. On the right, hit the first dropdown and
choose Workbook. You can choose other events on the right-hand dropdown, but
the Workbook_Open appears already, so just place your code between the
Private... and End Sub.
*******************
~Anne Troy
www.OfficeArticles.com
"Solly" <Solly@discussions.microsoft.com> wrote in message
news:8EF8038E-3732-4586-A2C2-D898AF5A89FF@microsoft.com...
> Hi
>
> How do I get macros or some code to run automatically when I start up an
> excel worksheet?
>
> Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks