How do you set a default macro in excel
 

Pantelis

You should save them in your Personal Macro Workbook which contains macros
available to all workbooks.

If you don't have a Personal Macro Workbook...........

On menu go to ToolsMacroRecord New Macro.

You will be presented with a dialog box with Macro1 as name of macro. Below
that is "Store macro in". Select Personal Macro Workbook.

Record something simple like copying a cell and pasting. Stop Recording.
Close Excel and you will be asked if you want to save changes to Personal.xls

Click Yes. You now have a Personal.xls in your XLSTART folder which will open
each time you start Excel. When it is open, you can go to WindowsHide and
make it hidden. Save changes again.

The macros you create or copy to modules in the Personal.xls will be available
for all workbooks.

Assign these macros to Buttons on your Toolbar.

Gord Dibben Excel MVP XL2002

On Mon, 1 Sep 2003 23:51:04 +0300, "Pantelis" wrote:

Hi all,

I'm trying to set up an icon on my toolbar that will be default for all my
excel operations.

any ideas will be appreciated

Pantelis

How do you set a default macro in excel
 

Thanks.

Guessed right this time<g

Gord

On Tue, 2 Sep 2003 23:21:49 +0300, "Pantelis" wrote:

Gordon,

Your method worked, thanks

Pantelis


"Gord Dibben" wrote in message
.. .
Pantelis

You should save them in your Personal Macro Workbook which contains macros
available to all workbooks.

If you don't have a Personal Macro Workbook...........

On menu go to ToolsMacroRecord New Macro.

You will be presented with a dialog box with Macro1 as name of macro.
Below
that is "Store macro in". Select Personal Macro Workbook.

Record something simple like copying a cell and pasting. Stop Recording.
Close Excel and you will be asked if you want to save changes to
Personal.xls

Click Yes. You now have a Personal.xls in your XLSTART folder which will
open
each time you start Excel. When it is open, you can go to WindowsHide
and
make it hidden. Save changes again.

The macros you create or copy to modules in the Personal.xls will be
available
for all workbooks.

Assign these macros to Buttons on your Toolbar.

Gord Dibben Excel MVP XL2002

On Mon, 1 Sep 2003 23:51:04 +0300, "Pantelis"
wrote:

Hi all,

I'm trying to set up an icon on my toolbar that will be default for all
my
excel operations.

any ideas will be appreciated

Pantelis