Re: Workbook still won't save customized QAT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <rondebruin@xxxxxxxxxxxx> wrote in message news:%23rhU1%232GKHA.1380@xxxxxxxxxxxxxxxxxxxxxxx
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" <si24392@xxxxxxxxxxx> wrote in message news:6d127fc7-97df-42a9-8cef-8c637afdefe8@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Aug 9, 1:20 pm, "Ron de Bruin" <rondebr...@xxxxxxxxxxxx> 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" <nodak...@xxxxxxxxx> wrote in messagenews:JI2dnXe_Mq-qjeLXnZ2dnUVZ_radnZ2d@xxxxxxxxxxxxxxx
> 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" <rondebr...@xxxxxxxxxxxx> wrote in message
>news:OMAANeMGKHA.4608@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi John

>> I not understand you, can you explain more

>> --

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

>> "John" <nodak...@xxxxxxxxx> wrote in message
>>news:J9idnYQ6OukYvePXnZ2dnUVZ_s-dnZ2d@xxxxxxxxxxxxxxx
>>> 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" <rondebr...@xxxxxxxxxxxx> wrote in message
>>>news:uXTKLSHGKHA.3800@xxxxxxxxxxxxxxxxxxxxxxx
>>>> 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" <nodak...@xxxxxxxxx> wrote in message
>>>>news:-JydnZm2_I8Mb-DXnZ2dnUVZ_gudnZ2d@xxxxxxxxxxxxxxx
>>>>> 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" <rondebr...@xxxxxxxxxxxx> wrote in message
>>>>>news:Oj6IyXGGKHA.3696@xxxxxxxxxxxxxxxxxxxxxxx
>>>>>> 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" <nodak...@xxxxxxxxx> wrote in message
>>>>>>news:AbqdnTp4qLQxKuDXnZ2dnUVZ_g6dnZ2d@xxxxxxxxxxxxxxx
>>>>>>>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!
.

Quantcast