Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Default zero with use macro | Excel Worksheet Functions | |||
VB Macro for cell colour default | Excel Discussion (Misc queries) | |||
excel macro to automatically change default printer | Excel Discussion (Misc queries) | |||
Default Macro | Setting up and Configuration of Excel |