Cannot save macro buttons in QAT

[OssieMac]

When xl2007 was introduced, one could add buttons to the QAT to run macros
and save them with the workbook. Now when that is done, the buttons only
remain visible until the workbook is closed and when re-opened the buttons
are not there.

Ron de Bruin (MVP) has a work around at the following URL but it should not
be required. Even with this workaround, if the workbook is renamed then it
does not work and if the workbook is copied, it opens the original workbook
and runs the code from there instead.

http://www.rondebruin.nl/qatbuttonbug.htm

Because this is a bug that has been introduced by Microsoft updates, it
should be treated with some urgency irrespective of how many votes it gets
from other users.

--
Regards,

OssieMac

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...b-abbc7c553efd&dg=microsoft.public.excel.misc

 

[Ron de Bruin]

Hi OssieMac

Ron de Bruin (MVP) has a work around at the following URL but it should not
be required. Even with this workaround, if the workbook is renamed then it
does not work and if the workbook is copied, it opens the original workbook
and runs the code from there instead.

I not see your problem after I make a copy of the file


--

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