Modify Quick Access Toolbars - icons

[Guest]

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.

 

[Guest]

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.

 

[Nick Hodge]

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
(e-mail address removed)
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