close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()