Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 crash when trying to add macro button to QAT
Hello:
I recently switched to Excel 2007 and am having difficulty adding a button to the Quick Access Toolbar so as to assign a macro to it. When I open Excel Options -Customize and try to choose Macros from the "Choose commands from" list, Excel crashes and generates a "MS Office Excel has encountered a problem and needs to close..." window. I have my macros open as hidden when Excel is launched. They show up in the macro list and run fine from there. Any suggestions would be much appreciated. Thanks! -- Ron |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 crash when trying to add macro button to QAT
Try to Run Office Diagnostics firts on
Office ButtonExcel Options...Resources -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron" wrote in message ... Hello: I recently switched to Excel 2007 and am having difficulty adding a button to the Quick Access Toolbar so as to assign a macro to it. When I open Excel Options -Customize and try to choose Macros from the "Choose commands from" list, Excel crashes and generates a "MS Office Excel has encountered a problem and needs to close..." window. I have my macros open as hidden when Excel is launched. They show up in the macro list and run fine from there. Any suggestions would be much appreciated. Thanks! -- Ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 crash when trying to add macro button to QAT
I figured it out myself. The macro worksheet needs to be unhidden for the
macros to load into the Excel Options-Customize-Choose commands from-Macros list. -- Ron "Ron" wrote: Hello: I recently switched to Excel 2007 and am having difficulty adding a button to the Quick Access Toolbar so as to assign a macro to it. When I open Excel Options -Customize and try to choose Macros from the "Choose commands from" list, Excel crashes and generates a "MS Office Excel has encountered a problem and needs to close..." window. I have my macros open as hidden when Excel is launched. They show up in the macro list and run fine from there. Any suggestions would be much appreciated. Thanks! -- Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert photo in Excel 2007 causes crash | Excel Discussion (Misc queries) | |||
Excel 2007 Office Button | Excel Discussion (Misc queries) | |||
How can I edit my macro button images in Excel 2007. | Excel Discussion (Misc queries) | |||
Do Large Workbooks Still Crash in Excel 2007 | Excel Discussion (Misc queries) | |||
Macro Glitch Causing Crash | Excel Discussion (Misc queries) |