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!
 
Try to Run Office Diagnostics firts on

Office Button>Excel Options...Resources
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run a macro from another workbook in the QAT 1
How to access macros via tool buttons? 2
Excel 2007: Help creating a macro that will run Solver? 3
Assigning Macros in Excel 2007 1
Startup Template - Excel 2007/Vista 7
Customize the QAT with text rather than image 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
add macro button 2007 2

Back
Top