Error Loading Custom UI XML

[sumdumgai]

I tried to customize the Quick Access Toolbar for a workbook named 'fname_test.xlsm' by adding an icon that runs a macro (Macro1). When I close the workbook and reopen it, I get the following error. When I answer 'OK' to the message, the icon is not there. Any help would be appreciated:

Error found in Custom UI XML:

Error Loading Custom UI XML
Line 1:
Column: 480
Error Code 0x80004005
A name contained an invalid character.
Error parsing
‘fname_test.xlsm_Macro1’ as QName datatype.
The attribute ‘idQ’ with value
‘fname_test.xlsm_Macro1’ failed to parse.

[Andy Pope]

Without seeing what you created it is hard to say, other than something is using an invalid character.

Have you read Ron de Bruin's pages on the QAT
http://www.rondebruin.nl/imageqat.htm

[sumdumgai]

Thanks for the info. I can use it to modify button images on the QAT which is something I wanted to do. I've customized the QAT many times before, but something has changed and I can no longer add buttons to the QAT. I've created and attached a test workbook that is empty but contains two macros. I've customized the QAT, adding a button for macro Test1. The button works when it is first created. When I close and reopen the workbook, however, the error occurs and the button is not there. Thanks for your help.

[sumdumgai]

This may have something to do with security patch KB969682. I believe this problem started after I installed that patch. I would uninstall it to test but I don't see the patch listed in the Control Panel's list of installed patches. Yet, when I try to install the patch, a message tells me that the patch is already installed. One other factor is that I have both Office 2003 and Office 2007 installed (installed 2003 first and then 2007).

[Andy Pope]

For me changing the .xlsx reference to .xlsm and removing the : between drive letter and folder made it work.

<mso:customUI xmlns:doc="http://schemas.microsoft.com/office/2006/01/customui/currentDocument" xmlns:mso="http://schemas.microsoft.com/office/2006/01/customui">
<mso:ribbon>
<mso:qat>
<mso:documentControls>
<mso:button idQ="doc:C_temp_test.xlsm_test1"
visible="true"
label="test1"
onAction="C:\temp\test.xlsm!test1"
imageMso="ListMacros"/></mso:documentControls></mso:qat></mso:ribbon></mso:customUI>