ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I have a macros automatically run when I open up the file. (https://www.excelbanter.com/excel-programming/311956-how-can-i-have-macros-automatically-run-when-i-open-up-file.html)

Owen[_2_]

How can I have a macros automatically run when I open up the file.
 
See subject line

Nick Hodge

How can I have a macros automatically run when I open up the file.
 
Owen

In versions after 95 use the Workbook_Open() event. In 95 and previous
(still supported in later versions) use and Auto_Open() macro

If you need help implementing, post back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Owen" wrote in message
...
See subject line




Gord Dibben

How can I have a macros automatically run when I open up the file.
 
Sub WorkBook_Open()

yourmacroname

End Sub

Gord Dibben Excel MVP

On Wed, 29 Sep 2004 13:35:03 -0700, "Owen"
wrote:

See subject line




All times are GMT +1. The time now is 02:02 PM.

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