#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Tool bars

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Tool bars

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tool bars and startup Pietro Excel Discussion (Misc queries) 4 February 18th 07 12:12 AM
Excel Tool Bars baileybw New Users to Excel 4 July 25th 06 04:58 AM
Attached tool bars WISE Excel Discussion (Misc queries) 3 February 14th 06 01:06 AM
TOOL BARS AND THEIR USAGE GMAROSE62 Excel Worksheet Functions 1 October 7th 05 07:18 AM
Lost all my menu bars and tool bars CathyJ Excel Discussion (Misc queries) 3 August 8th 05 12:49 PM


All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"