Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
I posted an earlier message regarding this problem, but have still not
resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
Hi John
It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
Hi Ron,
I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message ... Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
Hi John
Start here http://www.rondebruin.nl/ribbon.htm If you have problems let me know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Hi Ron, I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message ... Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
Thanks, I'll try that.
I noticed I can customize my QAT if I add an Excel button to my workbook. It fails when I add a macro to my workbook. Would this problem have anything to do with the VBE setting: Tools-References-Available References? "Ron de Bruin" wrote in message ... Hi John Start here http://www.rondebruin.nl/ribbon.htm If you have problems let me know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Hi Ron, I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message ... Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
Hi John
I not understand you, can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Thanks, I'll try that. I noticed I can customize my QAT if I add an Excel button to my workbook. It fails when I add a macro to my workbook. Would this problem have anything to do with the VBE setting: Tools-References-Available References? "Ron de Bruin" wrote in message ... Hi John Start here http://www.rondebruin.nl/ribbon.htm If you have problems let me know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Hi Ron, I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message ... Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
In Visual Basic on the menu bar, click on Tools/References.
I was wondering if those had anything to do with the QAT problem. "Ron de Bruin" wrote in message ... Hi John I not understand you, can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Thanks, I'll try that. I noticed I can customize my QAT if I add an Excel button to my workbook. It fails when I add a macro to my workbook. Would this problem have anything to do with the VBE setting: Tools-References-Available References? "Ron de Bruin" wrote in message ... Hi John Start here http://www.rondebruin.nl/ribbon.htm If you have problems let me know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Hi Ron, I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message ... Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
Hi John
The QAT problem is a bug and not only on your machine -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... In Visual Basic on the menu bar, click on Tools/References. I was wondering if those had anything to do with the QAT problem. "Ron de Bruin" wrote in message ... Hi John I not understand you, can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Thanks, I'll try that. I noticed I can customize my QAT if I add an Excel button to my workbook. It fails when I add a macro to my workbook. Would this problem have anything to do with the VBE setting: Tools-References-Available References? "Ron de Bruin" wrote in message ... Hi John Start here http://www.rondebruin.nl/ribbon.htm If you have problems let me know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Hi Ron, I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message ... Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
On Aug 9, 1:20*pm, "Ron de Bruin" wrote:
Hi John The QAT problem is a bug and not only on your machine -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "John" wrote in ... In Visual Basic on the menu bar, click on Tools/References. I was wondering if those had anything to do with the QAT problem. "Ron de Bruin" wrote in message ... Hi John I not understand you, can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Thanks, I'll try that. I noticed I can customize my QAT if I add an Excel button to my workbook. It fails when I add a macro to my workbook. Would this problem have anything to do with the VBE setting: Tools-References-Available References? "Ron de Bruin" wrote in message ... Hi John Start here http://www.rondebruin.nl/ribbon.htm If you have problems let me know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Hi Ron, I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message . .. Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? *Thanks. You have to remove all the paths inside the customUI.xml file and leave the macro names only. Detailed Solution: Rename your file with a .zip extension. Open the customUI.xml file in the userCustomization folder. For every button you have, there will be an "idQ" property. That property will have the full path of the macro. Remove the whole path except for the macro name so the format is like this: idQ="doc:MacroName_1" (you want to leave the "doc:" and the "_1" there) Also, remove the path from the onAction property: onAction="MacroName" That's it. Save the file, change it back to an .xlsm file, and the buttons are there! |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
Hi John
I see, not a very good fix for a normal user<g I hope they can fix it but it is a nasty bug Thanks for your reply -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "si24392" wrote in message ... On Aug 9, 1:20 pm, "Ron de Bruin" wrote: Hi John The QAT problem is a bug and not only on your machine -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "John" wrote in ... In Visual Basic on the menu bar, click on Tools/References. I was wondering if those had anything to do with the QAT problem. "Ron de Bruin" wrote in message ... Hi John I not understand you, can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Thanks, I'll try that. I noticed I can customize my QAT if I add an Excel button to my workbook. It fails when I add a macro to my workbook. Would this problem have anything to do with the VBE setting: Tools-References-Available References? "Ron de Bruin" wrote in message ... Hi John Start here http://www.rondebruin.nl/ribbon.htm If you have problems let me know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Hi Ron, I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message . .. Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. You have to remove all the paths inside the customUI.xml file and leave the macro names only. Detailed Solution: Rename your file with a .zip extension. Open the customUI.xml file in the userCustomization folder. For every button you have, there will be an "idQ" property. That property will have the full path of the macro. Remove the whole path except for the macro name so the format is like this: idQ="doc:MacroName_1" (you want to leave the "doc:" and the "_1" there) Also, remove the path from the onAction property: onAction="MacroName" That's it. Save the file, change it back to an .xlsm file, and the buttons are there! |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook still won't save customized QAT
Hi all
I create a draft page page of this bug http://www.rondebruin.nl/qatbuttonbug.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi John I see, not a very good fix for a normal user<g I hope they can fix it but it is a nasty bug Thanks for your reply -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "si24392" wrote in message ... On Aug 9, 1:20 pm, "Ron de Bruin" wrote: Hi John The QAT problem is a bug and not only on your machine -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "John" wrote in ... In Visual Basic on the menu bar, click on Tools/References. I was wondering if those had anything to do with the QAT problem. "Ron de Bruin" wrote in message ... Hi John I not understand you, can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Thanks, I'll try that. I noticed I can customize my QAT if I add an Excel button to my workbook. It fails when I add a macro to my workbook. Would this problem have anything to do with the VBE setting: Tools-References-Available References? "Ron de Bruin" wrote in message ... Hi John Start here http://www.rondebruin.nl/ribbon.htm If you have problems let me know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Hi Ron, I've never added a ribbon tab before, but that would probably work. The workbook will be passed around to dozens of co-workers when I'm finished so I need to have some sort of interface for them to access my macros. "Ron de Bruin" wrote in message . .. Hi John It looks like this is a bug in SP2 but I am not sure It is working OK for me on a system with no SP and also in the beta of Excel 2010 I report this bug so we must wait before it is fixed As a workaround you can add a ribbon tab ? Is that a option for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I posted an earlier message regarding this problem, but have still not resolved it (Excel 2007). I customize my QAT to include macros for my workbook. When I close, then reopen my workbook, the customized macro buttons are no longer on the QAT. The puzzling thing is, a month ago I had no problems saving macros on my QAT. Anyone know a work-around or have any ideas? Thanks. You have to remove all the paths inside the customUI.xml file and leave the macro names only. Detailed Solution: Rename your file with a .zip extension. Open the customUI.xml file in the userCustomization folder. For every button you have, there will be an "idQ" property. That property will have the full path of the macro. Remove the whole path except for the macro name so the format is like this: idQ="doc:MacroName_1" (you want to leave the "doc:" and the "_1" there) Also, remove the path from the onAction property: onAction="MacroName" That's it. Save the file, change it back to an .xlsm file, and the buttons are there! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook won't save customized QAT | Excel Programming | |||
Customized marcos cannot save to tools-bar | Excel Worksheet Functions | |||
how Do I save a customized Toolbar | Excel Programming | |||
Excel 2003 won't save customized changes | Excel Discussion (Misc queries) | |||
How can I save a customized Standard toolbar? | Excel Discussion (Misc queries) |