View Single Post
  #12   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

Yes

--

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




"Doug" wrote in message ...
Is this a good email

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



"Ron de Bruin" wrote:

Send me your workbook private and i take a look



--

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




"Doug" wrote in message ...
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" wrote:

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




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