Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot save macro buttons in QAT
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/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot save macro buttons in QAT
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 "OssieMac" wrote in message ... 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/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As and Save Buttons Don't Work | Excel Discussion (Misc queries) | |||
Macro buttons opening saved macro | Excel Discussion (Misc queries) | |||
save as, cut , copy and paste buttons are greyed out in Excel 2003 | Excel Discussion (Misc queries) | |||
hidden save buttons | Excel Discussion (Misc queries) | |||
Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working | Excel Worksheet Functions |