Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
We have just upgraded to Office 2007. Im having problem getting tool bars
back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We cant create your own icons anymore. In office 2007 you have to pick from a list of €śsymbol€ť that are available. If I could edit and or add my own €śsymbols€ť that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can assign macros to buttons/icons that can be placed in the QAT (Quick
Access Toolbar) -- Regards, Peo Sjoblom "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. I'm having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We can't create your own icons anymore. In office 2007 you have to pick from a list of "symbol" that are available. If I could edit and or add my own "symbols" that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not possible to add icons to the QAT icons
But maybe you can use one of the examples on my site if you want more icons See the 2007 section http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. Im having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We cant create your own icons anymore. In office 2007 you have to pick from a list of €śsymbol€ť that are available. If I could edit and or add my own €śsymbols€ť that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Now you made me unsure, I don't have 2007 where I am at the moment (I will
test it later today) but I believe I once tested and put a built in macro button in the QAT and assigned a macro to it, the button could be found in Office buttonExcel options where you customize the QAT if you scroll down to macros -- Regards, Peo Sjoblom "Ron de Bruin" wrote in message ... Not possible to add icons to the QAT icons But maybe you can use one of the examples on my site if you want more icons See the 2007 section http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. I'm having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We can't create your own icons anymore. In office 2007 you have to pick from a list of "symbol" that are available. If I could edit and or add my own "symbols" that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Peo
If I could edit and or add my own "symbols" that would fix my problem It is not possible to add other icons to the build-in icons that you can choose. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Now you made me unsure, I don't have 2007 where I am at the moment (I will test it later today) but I believe I once tested and put a built in macro button in the QAT and assigned a macro to it, the button could be found in Office buttonExcel options where you customize the QAT if you scroll down to macros -- Regards, Peo Sjoblom "Ron de Bruin" wrote in message ... Not possible to add icons to the QAT icons But maybe you can use one of the examples on my site if you want more icons See the 2007 section http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. I'm having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We can't create your own icons anymore. In office 2007 you have to pick from a list of "symbol" that are available. If I could edit and or add my own "symbols" that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know I can put an icon in the QAT but it will not let me customize the icon
Or what it call a symbol. This is what i need to fix. sorry maybe i wasn't very thorough in explaining my problem. Thanks for the responce, Russ "Peo Sjoblom" wrote: You can assign macros to buttons/icons that can be placed in the QAT (Quick Access Toolbar) -- Regards, Peo Sjoblom "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. I'm having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We can't create your own icons anymore. In office 2007 you have to pick from a list of "symbol" that are available. If I could edit and or add my own "symbols" that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In looking at your site there are a lot of interesting thing there.
If I use the Change Excel ribbon article that would replace the ribbon not add a tab correct. If that is correct I dont want to replace the ribbon. Thanks, Russ "Ron de Bruin" wrote: Not possible to add icons to the QAT icons But maybe you can use one of the examples on my site if you want more icons See the 2007 section http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. Im having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We cant create your own icons anymore. In office 2007 you have to pick from a list of €śsymbol€ť that are available. If I could edit and or add my own €śsymbols€ť that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Russ
There is also a example that create a new tab on the ribbon. Or add one group on a existing tab. Follow the steps and try the samples in the "Sample" menu in the UI editor. After that Try the XMLCreator 1.5 workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" wrote in message ... In looking at your site there are a lot of interesting thing there. If I use the Change Excel ribbon article that would replace the ribbon not add a tab correct. If that is correct I dont want to replace the ribbon. Thanks, Russ "Ron de Bruin" wrote: Not possible to add icons to the QAT icons But maybe you can use one of the examples on my site if you want more icons See the 2007 section http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. Im having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We cant create your own icons anymore. In office 2007 you have to pick from a list of €śsymbol€ť that are available. If I could edit and or add my own €śsymbols€ť that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I didn't mean that, I was thinking of the built in one, I obviously
misunderstood the OP -- Regards, Peo Sjoblom "Ron de Bruin" wrote in message ... Hi Peo If I could edit and or add my own "symbols" that would fix my problem It is not possible to add other icons to the build-in icons that you can choose. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Now you made me unsure, I don't have 2007 where I am at the moment (I will test it later today) but I believe I once tested and put a built in macro button in the QAT and assigned a macro to it, the button could be found in Office buttonExcel options where you customize the QAT if you scroll down to macros -- Regards, Peo Sjoblom "Ron de Bruin" wrote in message ... Not possible to add icons to the QAT icons But maybe you can use one of the examples on my site if you want more icons See the 2007 section http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. I'm having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We can't create your own icons anymore. In office 2007 you have to pick from a list of "symbol" that are available. If I could edit and or add my own "symbols" that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can as I stated in my other response to you setup the macro buttons in
the QAT but I need to use certain icon as I have 50 users that have used the same icons for 3 years to run macros and they are very familiar with them. Thanks again, Russ "Peo Sjoblom" wrote: Now you made me unsure, I don't have 2007 where I am at the moment (I will test it later today) but I believe I once tested and put a built in macro button in the QAT and assigned a macro to it, the button could be found in Office buttonExcel options where you customize the QAT if you scroll down to macros -- Regards, Peo Sjoblom "Ron de Bruin" wrote in message ... Not possible to add icons to the QAT icons But maybe you can use one of the examples on my site if you want more icons See the 2007 section http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. I'm having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We can't create your own icons anymore. In office 2007 you have to pick from a list of "symbol" that are available. If I could edit and or add my own "symbols" that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you use this example you will see that it is easier that changing the ribbon Russ.
You can use all old 97-2003 icins then, but it is your choice. http://www.rondebruin.nl/qat2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" wrote in message ... You can as I stated in my other response to you setup the macro buttons in the QAT but I need to use certain icon as I have 50 users that have used the same icons for 3 years to run macros and they are very familiar with them. Thanks again, Russ "Peo Sjoblom" wrote: Now you made me unsure, I don't have 2007 where I am at the moment (I will test it later today) but I believe I once tested and put a built in macro button in the QAT and assigned a macro to it, the button could be found in Office buttonExcel options where you customize the QAT if you scroll down to macros -- Regards, Peo Sjoblom "Ron de Bruin" wrote in message ... Not possible to add icons to the QAT icons But maybe you can use one of the examples on my site if you want more icons See the 2007 section http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rwilson@midwestcabinet" m wrote in message ... We have just upgraded to Office 2007. I'm having problem getting tool bars back up and running. From all that I have seen so far office has taken away a lot of the ability to customize tool bar unless you know how to use and have Visual Basics studio. We could purchase the program however we have no one that knows how to use it. We use a lot of macros to do various thing. We have created specific icons that are used to identify the function of these macros that are use when creating the toolbars of old. We can't create your own icons anymore. In office 2007 you have to pick from a list of "symbol" that are available. If I could edit and or add my own "symbols" that would fix my problem but I have been unsuccessful in finding out where those symbols are stored so that I can add to the list. Any ideas would be helpful. Thanks Russ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tool bars and startup | Excel Discussion (Misc queries) | |||
Excel Tool Bars | New Users to Excel | |||
Attached tool bars | Excel Discussion (Misc queries) | |||
TOOL BARS AND THEIR USAGE | Excel Worksheet Functions | |||
Lost all my menu bars and tool bars | Excel Discussion (Misc queries) |