Thread
:
XLSM File Will Not Save Macros in Quick Access Toolbar
View Single Post
#
4
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
You must save it as a add-in to avoid this in 2007
See this page for a example
http://www.rondebruin.nl/imageqat.htm
In 2010 we not have this problem anymore
Maybe you like this for 2007
http://www.rondebruin.nl/qat.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Louis Pace" wrote in message ...
Ah ha! Success! The buttons I added were in the XML file. They were just not
appearing on the QAT. I followed your instructions, and they reappeared. I
learned by experimenting that I can modify existing buttons, but if I add any
new buttons, then I lose the entire "this workbook" section of the QAT until
I re-edit the XML file. Hopefully this bug will be addressed by Microsoft
soon, but meanwhile, your workaround is easy and effective.
Thank you very much!
"Ron de Bruin" wrote:
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