Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
master macor
Is there a way that I can have a macro available on every workbook that I
create? What I'm trying to do is have formatting button so that every time I paste contents of a Access query into a new book I can have it autofit all my rows and columns. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
master macor
Store the macro in your personal.xls which is a file which is created first
time you record a macro & indicate to put it in the personal file. Then it exists in the xlstart directory. If you already have this macro somewhere else, copy/paste it into the personal.xls and it will always be available. Bob Umlas Excel MVP "Neil" wrote in message ... Is there a way that I can have a macro available on every workbook that I create? What I'm trying to do is have formatting button so that every time I paste contents of a Access query into a new book I can have it autofit all my rows and columns. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master Sheet | Excel Worksheet Functions | |||
using a master reference | Excel Worksheet Functions | |||
How to create a macor to count the usage of another macor | Excel Discussion (Misc queries) | |||
Master worksheets? | Excel Worksheet Functions | |||
Excel-Master | Excel Worksheet Functions |