Thread
:
Quick Access Tool Bar won't save customization
View Single Post
#
13
Posted to microsoft.public.excel.misc
Ron de Bruin
external usenet poster
Posts: 11,123
Quick Access Tool Bar won't save customization
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
"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!
Reply With Quote
Ron de Bruin
View Public Profile
Find all posts by Ron de Bruin