Toolbar Buttons

T

TomD

When customising or creating new Toolbars there is an
option to change the button image. The selection is
small and limited. Is there any way that this selection
can be modified and/or added to to give a better and
larger auto choice.
 
E

Earl Kiosterud

Tom,

The button image screen has low resolution, but keep in mind that the
buttons are small, and a lot of detail wouldn't be seen, even if displayed.
 
T

TomD

Earl,

I'm not sure I understand your reply in context.....

I've created a new toolbar and initially changed the
buttons for one of the 42 (7 x 6) directly available. If
these have not be suitable, I've modified one or
completely made new one. The resolution of these images
are (16 x 16). What I like to do is to increase the
selection of 42. Can this be done and would the
resolution be limited to 16 x 16
 
E

Earl Kiosterud

Tom,

There seem to be two issues here. One is the count of available buttons,
the other is the resolution of the button images.

There are many, probably over a hundred, toolbar buttons in the various
categories, so I'm not sure what you mean by 42 (7x6). For any button
action outside of the available buttons, you would write (or record) your
own macro, and assign it to any button. Or create new buttons from existing
buttons, or just start with good old "Custom button," a smiley face in the
Macro category that doesn't do anything (until you've assigned it to a
macro). Then edit its image to suit. I don't know of any limit to the
number of such custom buttons.

As for the resolution, I think I must stand by my statement. If you go into
Customize (View - Toolbars - Customize), then while that dialog is open,
right click any button on a toolbar (in the Excel window), and choose "Edit
button Image," you'll see a pretty rough (16x16, as you said) rendering.
That same image looks plenty resolute enough in the normal small size of the
button.

I might be missing the point still. Please post back if I have.
 
T

TomD

Earl,

Clarification........

Open Excel worksheet.
Right mouse click on toolbar and select customize
Select a button on toobar and right click mouse
Select "Change Button Image"..........

Here you will see 42 button images to choose from in a 6
x 7 matrix each with resolution of 16 x 16 pixels. What
I would like to do is to add more imags to this 42
image "window"; say 100 in total i.e have a better
choice. However I don't know if this is possible or
where the original 42 images are stored/can be found.
 
E

Earl Kiosterud

Tom,

Hadn't noticed Change Button Image. Normally, you just use any existing
button, then Edit Button Image, and draw your own, and change the macro to
which it's assigned. I don't know about adding them to that 7x6 store.
Here are some things that may help: After creating your own button, you can
Ctrl-Drag to copy it to the same or another toolbar. There's also (with
right-click) Copy and Paste Button Image. You have to have put some button
there to paste over, though. You can right-click any button and assign it
to a different macro.
 
Top