View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Creating a macro for all future spreadsheets

Store the macro in your personal.xls file. This allows you to use the macro
whenever you have Excel open.

--
Brevity is the soul of wit.


"epicman" wrote:

I have created a macro however it will only work within that
spreadsheet. How can i write a macro so that all of my documents
(existing and new) can use this macro.

I then wish to assign a button on the toolbar that uses that macro.