Thread
:
XLSM File Will Not Save Macros in Quick Access Toolbar
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ron de Bruin
external usenet poster
Posts: 11,123
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.
Reply With Quote
Ron de Bruin
View Public Profile
Find all posts by Ron de Bruin