Excel 2007 Toolbar Icons

[Guest]

In Excel 2003 and previous versions, the "Paste Values" command had a
distinctive icon, a clipboard with numbers. Other commands had their own
distinctive icons.

In Excel 2007, these distinctive icons have apparently been removed. When I
add these commands to the Quick Access Toolbar, I get a row of green shaded
circles, which (I hope you understand) is annoying. Is there any way to get
the distinctive icons back, or to substitute my own icons?

Also, the increase/decrease decimal icons used to have the larger number of
decimals on top or on bottom, to make it easier to identify the action. The
new icons are distinguished by an almost indiscernible arrow... Is there any
way to fix this?

Thank you.

 

[Guest]

I think the news is bad on this one. I posted a similar post on 4/7/2007 and
have gotten no responses. Typical of MSoft: we've thought of everything so
why would you want to customize. SO annoying. Every iteration takes more
and more control away from the user under the guise of "ease of use". Ha!

 

[Murph]

My solution was to open a personsal.xlsb each time with code I have been
using since 1997.
Ypu can add an icon to your menue bar if the quick key will conflict.

Sub paste_value()
''
' Keyboard Shortcut: Ctrl+v
'

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub