ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do you setup a auto run marco to run when excel opens? (https://www.excelbanter.com/excel-programming/323238-how-do-you-setup-auto-run-marco-run-when-excel-opens.html)

big D

how do you setup a auto run marco to run when excel opens?
 
Help! How do you setup a auto run marco in Excel 2003, to run when excel opens?

Robin Hammond[_2_]

how do you setup a auto run marco to run when excel opens?
 
The simplest way is to create an Auto_Open macro in your personal.xls file.
This is a hidden file that opens automatically when excel is run. It is
typically stored in C:\Program Files\Office Installation
folder\OfficeNN\xlstart

Robin Hammond
www.enhanceddatasystems.com

"Big D" <Big wrote in message
...
Help! How do you setup a auto run marco in Excel 2003, to run when excel
opens?





All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com