View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Quick Access Tool Bar won't save customization

See the link I posted

--

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




"Doug" wrote in message ...
"Doug" wrote:

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" wrote:

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




"Doug" wrote in message ...
It is an .xlsm file and it is a personal file.
--



"Ron de Bruin" wrote:

Hi Doug

What is the format of the workbook ?

Is it your personal file ???



--

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




"Doug" wrote in message ...
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.
--
Thank you!