S
Sue Parsons
Hi,
How do i set up a new icon of my own and assign a macro to it?
How do i set up a new icon of my own and assign a macro to it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
If by icon you mean a graphic on the worksheet, you can insert just about any
kind of picture on the worksheet (ClipArt say); right-click the picture and
assign a macro to it.
If by icon you mean want want a custom button with a graphic on it, put a
button on the worksheet using the Controls toolbar. Right-click the button
and assign both a picture and a macro.
kind of picture on the worksheet (ClipArt say); right-click the picture and
assign a macro to it.
If by icon you mean want want a custom button with a graphic on it, put a
button on the worksheet using the Controls toolbar. Right-click the button
and assign both a picture and a macro.
G
Gord Dibben
An alternative to the student's method............
Tools>Customize>Commands.
Scroll down to Macros and select.
From rightside pane drag the smiley face icon to a Toolbar.
Right-click on that icon and "assign macro".
You can also change the graphic by "change button image"
Gord Dibben MS Excel MVP
Tools>Customize>Commands.
Scroll down to Macros and select.
From rightside pane drag the smiley face icon to a Toolbar.
Right-click on that icon and "assign macro".
You can also change the graphic by "change button image"
Gord Dibben MS Excel MVP
S
Sue Parsons
Hi Yes this is the old 2003 you can do that but i have not been able to do
this in the 2007 there are no smiley face's
this in the 2007 there are no smiley face's
G
Gord Dibben
I know next to nothing about Excel 2007 since I have not yet installed.
Gord
Gord
G
Gord Dibben
Try Ron de Bruin's site for a look at the menu structure of 2007.
http://www.rondebruin.nl/0307commands.htm
Gord
http://www.rondebruin.nl/0307commands.htm
Gord