| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
Hi,
How do i set up a new icon of my own and assign a macro to it? -- sue |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excell
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. -- Gary''s Student - gsnu200758 "Sue Parsons" wrote: Hi, How do i set up a new icon of my own and assign a macro to it? -- sue |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excell
An alternative to the student's method............
ToolsCustomizeCommands. 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 On Wed, 21 Nov 2007 05:57:01 -0800, Sue Parsons wrote: Hi, How do i set up a new icon of my own and assign a macro to it? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excell
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 -- sue "Gord Dibben" wrote: An alternative to the student's method............ ToolsCustomizeCommands. 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 On Wed, 21 Nov 2007 05:57:01 -0800, Sue Parsons wrote: Hi, How do i set up a new icon of my own and assign a macro to it? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excell
I know next to nothing about Excel 2007 since I have not yet installed.
Gord On Thu, 22 Nov 2007 02:29:00 -0800, Sue Parsons wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excell
Try Ron de Bruin's site for a look at the menu structure of 2007.
http://www.rondebruin.nl/0307commands.htm Gord On Thu, 22 Nov 2007 08:55:39 -0800, Gord Dibben <gorddibbATshawDOTca wrote: I know next to nothing about Excel 2007 since I have not yet installed. Gord On Thu, 22 Nov 2007 02:29:00 -0800, Sue Parsons wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
| create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
| Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
| how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
| Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
Linear Mode
