View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin McCartney Kevin McCartney is offline
external usenet poster
 
Posts: 67
Default Creating a "Defualt" macro that is available in any and/all workbo

Hi Darin,

Sure it is, you need to place you required macro into an Excel workbook
addin, this way when you start Excel your workbook addin is loaded and you
macro is available for all workbooks. You can create an Excel workbook addin
by selecting from the menu bar File | Save As and from the Save As dialogue
box chenage the File As Type to "Microsoft Excel Addin *.xla" it will
automatically save it in your profile Excel Addins folder, so that after
saving the file, from the menu bar select Tools | Addins and from the Addins
pop up box select the browse button. You should see you recently new Addin
File, select it and click on OK. You workbook addin will now be loaded each
time you start Excel, thus your macro is now available.

Hope this helps

ciao
KM

"Darin" wrote:

Pretty simple question, thank you in advance for any help or answers.

Is it possible to create a macro that can be used in any and/or all Excel
workbooks? Essentially a "default" type macro that is available in all new or
existing workbooks.