Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons?
Thank you in advance. I've bee hoping to find a solution to this problem for years.
I setup Excel, that its 2003 isn't relevant to me. I have a dozen plus macro buttons on toolbars to the left and right of the screen. I need to keep assigning the correct macro to its button every time I start up. I keep my macro sheet in my Files\Core folder and a shortcut to it in Office 11/Xlstart. I save and back up both my macro sheet and my Excel11.xlb. I copy the Excel11.xlb into administrator(me)\application data\ Microsoft\excel\Xlstart.. Is there a better way I could do all this. Because of hardware 'issues' with my fallin' apart dual ccore. I will be rebuilding it and reinstalling Office 2003(I own it, can't afford another BiggerBetter Version, and I like it.. I'll run XP until I rebuilt my computer then buy Win7 64. Any help on how to configure Excel's macro buttons simpler, easier. would be very much appreciated. Thank You, Brian Day |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resetting up Excel 2003. Is there a fast simple way to re-associate macros with macro buttons?
It happens that Brian Day formulated :
Thank you in advance. I've bee hoping to find a solution to this problem for years. I setup Excel, that its 2003 isn't relevant to me. I have a dozen plus macro buttons on toolbars to the left and right of the screen. I need to keep assigning the correct macro to its button every time I start up. I keep my macro sheet in my Files\Core folder and a shortcut to it in Office 11/Xlstart. I save and back up both my macro sheet and my Excel11.xlb. I copy the Excel11.xlb into administrator(me)\application data\ Microsoft\excel\Xlstart. Is there a better way I could do all this. Because of hardware 'issues' with my fallin' apart dual ccore. I will be rebuilding it and reinstalling Office 2003(I own it, can't afford another BiggerBetter Version, and I like it. I'll run XP until I rebuilt my computer then buy Win7 64. Any help on how to configure Excel's macro buttons simpler, easier. would be very much appreciated. Thank You, Brian Day Normally, once a macro is assigned to a menuitem/button it should persist. How I do it is to have my macro workbooks create their toolbars/menus at startup and remove them at shutdown so there's no residual changes to Excel's UI. In some cases I assign keyboard shortcuts via the MacrosOptions instead of menus/toolbars. These persist as well unless I have other files open using the same shortcuts. In this case the last file opened gets preference if not the active workbook. (ActiveWorkbook gets preference by default) Some files are saved as hidden XLSs as is PERSONAL.XLS, and some are saved as XLAs. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a simple insert pic macro in Excel 2003 | Excel Programming | |||
Excel 2003 color resetting problem | Excel Discussion (Misc queries) | |||
Resetting Buttons in Macro | New Users to Excel | |||
resetting options buttons | Excel Programming | |||
resetting custom buttons for macro | Excel Programming |