Creating a global macro

's Computer Specifications

How do I create a macro that is available to all my Excel docs (like
normal.dot in Word)?

's Computer Specifications

Start the macro recorder. In the following dialog, field "Store macro in",
select "Personal macro workbook" and this will be generated for you on
recording. This is the place to store all general macros you need.

HTH. Best wishes Harald

"Jack B. Pollack" <(E-Mail Removed)> wrote in message
news:OXU6%(E-Mail Removed)...
> How do I create a macro that is available to all my Excel docs (like
> normal.dot in Word)?
>
>

's Computer Specifications

Thanks

"Harald Staff" <(E-Mail Removed)> wrote in message
news:ezo#(E-Mail Removed)...
> Start the macro recorder. In the following dialog, field "Store macro in",
> select "Personal macro workbook" and this will be generated for you on
> recording. This is the place to store all general macros you need.
>
> HTH. Best wishes Harald
>
> "Jack B. Pollack" <(E-Mail Removed)> wrote in message
> news:OXU6%(E-Mail Removed)...
> > How do I create a macro that is available to all my Excel docs (like
> > normal.dot in Word)?
> >
> >
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do i reuse a Excel macro on another worksheets, global macro?	=?Utf-8?B?R2xvYmFsIE1hY3JvPw==?=	Microsoft Excel Programming	1	1st Nov 2006 04:50 PM
Creating a global variable how to ?	Carlos	Microsoft C# .NET	7	24th Oct 2005 08:30 PM
Macro: Creating a Global One for All Presentations?	J. Danniel	Microsoft Powerpoint	2	27th Feb 2004 10:40 PM
How do I make a macro global... i.e. what is the global template for excel	deb	Microsoft Excel Worksheet Functions	1	16th Oct 2003 10:11 PM
Creating Global Macros	Mark L-Z	Microsoft Excel Programming	3	5th Aug 2003 10:08 PM