Excell

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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
 
I know next to nothing about Excel 2007 since I have not yet installed.

Gord
 
You must log in or register to reply here.

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

Similar Threads

Redefining the $ icons format 5
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Macro code behind button 1
setting up a inputbox with a number value 1
Create A Button and Assign A Macro To It 2
Solver Compiler issue 2
Sharing Macros 1
VBA to select font/colour not working 1

Back
Top