Excel 2007 crash when trying to add macro button to QAT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Back
Top