ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   On Open Macro (https://www.excelbanter.com/excel-discussion-misc-queries/80983-open-macro.html)

Tom

On Open Macro
 
When I open a particuliar workbook I would like to run a master macro
automatically. How can I make this happen?
TFTH,
Tom

Chip Pearson

On Open Macro
 
Name the macro Auto_Open and it will execute when the workbook is
opened.


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


"Tom" wrote in message
...
When I open a particuliar workbook I would like to run a master
macro
automatically. How can I make this happen?
TFTH,
Tom




Chip Smith

On Open Macro
 
you could also set another private sub that will look like this..

Private Sub Workbook_Open()

enter macro name here

End Sub

--
--Chip Smith--
MVP Wannabe :)


"Chip Pearson" wrote:

Name the macro Auto_Open and it will execute when the workbook is
opened.


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


"Tom" wrote in message
...
When I open a particuliar workbook I would like to run a master
macro
automatically. How can I make this happen?
TFTH,
Tom






All times are GMT +1. The time now is 01:41 AM.

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