View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default XLSM File Will Not Save Macros in Quick Access Toolbar

Hi Louis Pace

See this page
http://www.rondebruin.nl/qatbuttonbug.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Louis Pace" <Louis wrote in message ...
I have a workbook with several macros to automate repetitive tasks. The tasks
are so repetitive that I added the macros to the Quick Access Toolbar. I
added the buttons "for this workbook only", because I don't need them in
every workbook (and they aren't available in any other workbooks). I save the
file, close it, and re-open it. I then see that the "this workbook only" part
of the QAT is completely gone.

I assume this is a bug, because if it were by design, then there would be no
point in allowing macros to be added to the toolbar. Also, I have added
macros to QATs on other computers. The problem seems limited to my computer.
The problem is NOT limited to one workbook; I can reproduce the issue at will
with any XLSM file.

Many internet searches have yielded no help. Does anyone have any ideas?

Thank you.