PC Review


Reply
Thread Tools Rate Thread

How to add macro on QAT in excel 2007 after reopen

 
 
Leon
Guest
Posts: n/a
 
      18th Nov 2009

 
Reply With Quote
 
 
 
 
Bob I
Guest
Posts: n/a
 
      18th Nov 2009
Please use this area to pose your question.

Leon wrote:

 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      19th Nov 2009
I think this is your problem

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


--

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


"Leon" <(E-Mail Removed)> wrote in message news:2A9C8770-DFC7-4B88-A8E2-(E-Mail Removed)...
>

 
Reply With Quote
 
Sands
Guest
Posts: n/a
 
      13th Jan 2010

Hi

I want to add a macro to the QAT for a single workbook. I can add the macro
to the QAT, change the icon, etc but when I reopen the workbook the macro is
no longer on the QAT.
Please tell me there is a simple workaround for this that doesn't involve
opening zip files and editing xml file etc.
Thanks for any help
 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      13th Jan 2010
It is a bug and this is the only way to fix it

--

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


"Sands" <(E-Mail Removed)> wrote in message news:FB5AD646-3A65-45D7-A1F9-(E-Mail Removed)...
>
> Hi
>
> I want to add a macro to the QAT for a single workbook. I can add the macro
> to the QAT, change the icon, etc but when I reopen the workbook the macro is
> no longer on the QAT.
> Please tell me there is a simple workaround for this that doesn't involve
> opening zip files and editing xml file etc.
> Thanks for any help

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recorded macro fails after save, close, then reopen Marvin Buzz Microsoft Excel Programming 7 19th Aug 2008 12:26 AM
VB Macro button on menu Bar disappears when I reopen Outlook 2003 K4CYC Microsoft Outlook Discussion 1 15th Jul 2008 06:16 PM
Excel 2007 Macro Help (Excel 2003 not working in 2007) Pman Microsoft Excel Misc 4 29th May 2008 06:29 PM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort =?Utf-8?B?R2F2aW4=?= Microsoft Excel Worksheet Functions 0 17th May 2007 01:20 PM
Can't reopen macro-generated file Ion Chalmers Freeman Microsoft Excel Crashes 1 7th Dec 2003 01:52 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:56 PM.