ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Modify Quick Access Toolbars - icons (https://www.excelbanter.com/new-users-excel/139063-modify-quick-access-toolbars-icons.html)

3phoenix

Modify Quick Access Toolbars - icons
 
I just bought Office 2007, and I have two questions regarding Quick Access
Toolbars.
1. I use Excel frequently, and I am taking advantage of the quick access
toolbars (below the ribbon). Unfortunately, when you insert commads to QAT,
command icons without pre-assigned graphic appear as "green dots", i.e. paste
formula and paste value commands. Is there a way to change this - I don't
know why MS do not provide tools to solve this proble, like custom icon
designer.

2. Under the same heading, when I add command in "Customizing the QAT"
section, I noticed that "Modify" button (located next to "Add") button is
grayed out. I suspect that this will actually help me with my question #1,
but I don't know how to access this. Can someone help me?

Really appreciate it!

P.S. I really don't want to use macros or programs unless MS designed it
and included in the patch.

Luke Moraga

Modify Quick Access Toolbars - icons
 
I'm afraid I don't know the answer to modifying icons, but in answer to your
2nd question:

I found that when I click on one of the buttons already in my toolbars
(below the ribbon) this option is no longer grayed out. Sadly, it still does
not appear to have a modify icon feature.
--
Best Regards,

Luke Moraga


"3phoenix" wrote:

I just bought Office 2007, and I have two questions regarding Quick Access
Toolbars.
1. I use Excel frequently, and I am taking advantage of the quick access
toolbars (below the ribbon). Unfortunately, when you insert commads to QAT,
command icons without pre-assigned graphic appear as "green dots", i.e. paste
formula and paste value commands. Is there a way to change this - I don't
know why MS do not provide tools to solve this proble, like custom icon
designer.

2. Under the same heading, when I add command in "Customizing the QAT"
section, I noticed that "Modify" button (located next to "Add") button is
grayed out. I suspect that this will actually help me with my question #1,
but I don't know how to access this. Can someone help me?

Really appreciate it!

P.S. I really don't want to use macros or programs unless MS designed it
and included in the patch.


Nick Hodge

Modify Quick Access Toolbars - icons
 
The modify item lights up when you drag a macro to the QAT toolbar button
list. (They have a diagram type icon by default), you can then press modify
and a rather inadequate list of available icons is shown. That's it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Luke Moraga" wrote in message
...
I'm afraid I don't know the answer to modifying icons, but in answer to
your
2nd question:

I found that when I click on one of the buttons already in my toolbars
(below the ribbon) this option is no longer grayed out. Sadly, it still
does
not appear to have a modify icon feature.
--
Best Regards,

Luke Moraga


"3phoenix" wrote:

I just bought Office 2007, and I have two questions regarding Quick
Access
Toolbars.
1. I use Excel frequently, and I am taking advantage of the quick access
toolbars (below the ribbon). Unfortunately, when you insert commads to
QAT,
command icons without pre-assigned graphic appear as "green dots", i.e.
paste
formula and paste value commands. Is there a way to change this - I
don't
know why MS do not provide tools to solve this proble, like custom icon
designer.

2. Under the same heading, when I add command in "Customizing the QAT"
section, I noticed that "Modify" button (located next to "Add") button is
grayed out. I suspect that this will actually help me with my question
#1,
but I don't know how to access this. Can someone help me?

Really appreciate it!

P.S. I really don't want to use macros or programs unless MS designed it
and included in the patch.




All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com