Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default creating a macro icon

I created a macro, how do I create the icon so someone can just click the
icon and it runs?

Thanks

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default creating a macro icon

Make the forms toolbar visible.

click on the button control and rubberband it onto your sheet

It should prompt you to assign a macro.

Select you macro

Now click the button.

Similarly, you can go into tools=customize and create a button on a menu
and again, assign you macro to that.

--
Regards,
Tom Ogilvy


"ashaback" wrote:

I created a macro, how do I create the icon so someone can just click the
icon and it runs?

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CREATING NEW OR ADDING ICON SETS FOR CONDITIONAL FORMATTING Frank Excel Discussion (Misc queries) 0 February 27th 10 06:40 PM
Icon Sets - Display icon in one cell depending upon value in anoth Nolene Excel Worksheet Functions 2 February 26th 10 05:43 AM
Conditional formatting icon sets - creating a legend? dbagby Excel Discussion (Misc queries) 0 October 6th 09 05:17 PM
Icon Macro al007 Excel Programming 2 November 12th 05 03:00 PM
macro icon JIM.H.[_2_] Excel Programming 2 September 19th 04 09:00 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"