Excel 2007 Toolbar Icons

J

JonathanS

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.
 
G

Guackyxxx

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!
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top