Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 86
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple Macro help? The Message Excel Discussion (Misc queries) 2 December 14th 09 06:14 PM
simple macro widman Excel Discussion (Misc queries) 7 June 7th 08 08:57 PM
Help with simple macro Sam Commar Excel Discussion (Misc queries) 3 April 15th 08 04:30 PM
a simple macro? asalerno Excel Discussion (Misc queries) 2 April 28th 06 12:45 AM
Need Help With A Very Simple Macro Amca Excel Discussion (Misc queries) 3 May 7th 05 12:10 AM


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"