Quick Access Tool Bar won't save customization

[Doug]

I have several macros that I use and put them on the quick access tool bar
for ease of use. After I have saved the workbook and close it, I then open it
back up and they have been removed. Is there any likely solution for this?
The commands that I am trying to put in are 5 macros that I use to filter a
table and 1 command to clear filter.

 

[Ron de Bruin]

Hi Doug

What is the format of the workbook ?

Is it your personal file ???

 

[Doug]

It is an .xlsm file and it is a personal file.

 

[Ron de Bruin]

Hi Doug

It is an .xlsm file and it is a personal file.

If the file is hidden it also hide the QAT or Ribbon changes that you made with RibbonX
Do you see it if you unhide the file ?

Save it as a Add-in and you will see it


--

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

It is an .xlsm file and it is a personal file.

 

[Doug]

I just looked in the properties of the file to make sure and it is not a
hidden file.
I am not sure what you mean by Save it as a Add-in and you will see it
though. Is there another way to save the customization to the Quick Access
Tool Bar?

 

[Doug]

I just looked in the properties of the file to make sure and it is not a
hidden file.
I am not sure what you mean by Save it as a Add-in and you will see it
though. Is there another way to save the customization to the Quick Access
Tool Bar?

I just noticed that it will save it in general but won't save it for only
this particular workbook. I don't want the macros available by default
though in other excel files.

 

[Ron de Bruin]

If you hide a workbook (View > Hide) you not see your changes
For example personal.xlsb is a hidden workbook

Follow the steps on this page
http://www.rondebruin.nl/imageqat.htm



--

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

I just looked in the properties of the file to make sure and it is not a
hidden file.
I am not sure what you mean by Save it as a Add-in and you will see it
though. Is there another way to save the customization to the Quick Access
Tool Bar?

 

[Ron de Bruin]

See the link I posted

--

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

 

[Doug]

I followed everything on the link. Even changed the Add-in. It now looks like
an M when I open the workbook, but it still doesn't remember the macros that
I add to the QAT when I close out of the workbook...

 

[Ron de Bruin]

Send me your workbook private and i take a look



--

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

I followed everything on the link. Even changed the Add-in. It now looks like
an M when I open the workbook, but it still doesn't remember the macros that
I add to the QAT when I close out of the workbook...

 

[Doug]

Is this a good email (e-mail address removed)

I tried sending and it wouldn't.
Mail System Error - Returned Mail

 

[Ron de Bruin]

Yes

--

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

 

[Ron de Bruin]

More info here

I create a draft page about it today
http://www.rondebruin.nl/qatbuttonbug.htm

I hope you can test it and let me know if it is working OK


--

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