Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with a simple macro
Hi,
I often have to set up auto filter on the first line, freeze that pane and auto width the columns. It happens so often that I recorded a macro to do it for me. My problem is that I use so many different spreadsheets and I can never find the macro again.. Can someone please tell me how to save the macro so that it is available anytime that I open excel (2003) Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with a simple macro
Roger Dodger presented the following explanation :
Hi, I often have to set up auto filter on the first line, freeze that pane and auto width the columns. It happens so often that I recorded a macro to do it for me. My problem is that I use so many different spreadsheets and I can never find the macro again.. Can someone please tell me how to save the macro so that it is available anytime that I open excel (2003) Thanks in advance If you save the macro in 'PERSONAL.XLS' it will always be available when Excel is running. (Does NOT apply to automated instances of Excel) The macro recorder dialog asks you where you want to put the macro. PERSONAL.XLS is a good place to store all macros you reuse often. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with a simple macro
Save it to your Personal.xls file. See help for more on that subject.
Or put the macro in a module in a new workbook then save that workbook as an Add-in............my preference. Install through ToolsAdd-ins and leave it loaded. Gord Dibben Microsoft Excel MVP On Fri, 26 Aug 2011 11:18:36 +1000, "Roger Dodger" wrote: Hi, I often have to set up auto filter on the first line, freeze that pane and auto width the columns. It happens so often that I recorded a macro to do it for me. My problem is that I use so many different spreadsheets and I can never find the macro again.. Can someone please tell me how to save the macro so that it is available anytime that I open excel (2003) Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Macro help? | Excel Discussion (Misc queries) | |||
simple macro | Excel Discussion (Misc queries) | |||
Help with simple macro | Excel Discussion (Misc queries) | |||
a simple macro? | Excel Discussion (Misc queries) | |||
Need Help With A Very Simple Macro | Excel Discussion (Misc queries) |