When I open a particuliar workbook I would like to run a master macro
automatically. How can I make this happen?
TFTH,
Tom
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.comquot;Tomquot; gt; wrote in message
...
gt; When I open a particuliar workbook I would like to run a master
gt; macro
gt; automatically. How can I make this happen?
gt; TFTH,
gt; Tom
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 quot;Chip Pearsonquot; wrote:
gt; Name the macro Auto_Open and it will execute when the workbook is
gt; opened.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Tomquot; gt; wrote in message
gt; ...
gt; gt; When I open a particuliar workbook I would like to run a master
gt; gt; macro
gt; gt; automatically. How can I make this happen?
gt; gt; TFTH,
gt; gt; Tom
gt;
gt;
gt;
- Aug 07 Thu 2008 20:46
On Open Macro
close
全站熱搜
留言列表
發表留言