| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick Access Tool Bar won't save customization
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick Access Tool Bar won't save customization
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick Access Tool Bar won't save customization
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick Access Tool Bar won't save customization
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick Access Tool Bar won't save customization
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick Access Tool Bar won't save customization
"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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick Access Tool Bar won't save customization
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! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick Access Tool Bar won't save customization
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! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick Access Tool Bar won't save customization
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! |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Quick Access Toolbar | Excel Discussion (Misc queries) | |||
| How do I copy quick access tool bar to another computer? | Excel Discussion (Misc queries) | |||
| add text to the icons in the quick access tool bar | Setting up and Configuration of Excel | |||
| quick access toolbar | Excel Discussion (Misc queries) | |||
| quick access bar | Excel Discussion (Misc queries) | |||
Linear Mode
