Apply code to Icon

's Computer Specifications

How can I take some code I have on one worksheet that does formatting and
apply it to an icon that will display in the toolbar every time I open Excel
and every workbook?
--
Gator

's Computer Specifications

Place the code into your Personal.xls which will load hidden each time Excel is
started. Macros will be available for all open workbooks.

OR into a new workbook which you then save as an Add-in.

Load through Tools>Add-ins and it will remain active for all open workbooks.

I either case, assign the macro to a button through

Tools>Customize>Commands>Macros. Drag the Smiley Face to your Toolbar and

right-click and "Asign Macro".

Note: you can edit the name and image of the button.

Gord Dibben MS Excel MVP

On Fri, 4 Jan 2008 12:20:01 -0800, Gator <(E-Mail Removed)>
wrote:

>How can I take some code I have on one worksheet that does formatting and
>apply it to an icon that will display in the toolbar every time I open Excel
>and every workbook?

's Computer Specifications

How to I assign the sub-procedure to a macro?
--
Gator

"Gord Dibben" wrote:

> Place the code into your Personal.xls which will load hidden each time Excel is
> started. Macros will be available for all open workbooks.
>
> OR into a new workbook which you then save as an Add-in.
>
> Load through Tools>Add-ins and it will remain active for all open workbooks.
>
> I either case, assign the macro to a button through
>
> Tools>Customize>Commands>Macros. Drag the Smiley Face to your Toolbar and
>
> right-click and "Asign Macro".
>
> Note: you can edit the name and image of the button.
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 4 Jan 2008 12:20:01 -0800, Gator <(E-Mail Removed)>
> wrote:
>
> >How can I take some code I have on one worksheet that does formatting and
> >apply it to an icon that will display in the toolbar every time I open Excel
> >and every workbook?
>
>

's Computer Specifications

You mean assign the macro to a button?

Right-click on the button and "Assign Macro"

If the macro is stored in an add-in you must type in the name of the macro.

If in Personal.xls just select from the dialog and OK

Gord

On Fri, 4 Jan 2008 13:31:06 -0800, Gator <(E-Mail Removed)>
wrote:

>How to I assign the sub-procedure to a macro?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can Word 2007 apply a zip code bar code to envelopes?	=?Utf-8?B?TElOREE=?=	Microsoft Word Document Management	4	5th Jan 2008 04:45 AM
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code.	Corey	Microsoft Excel Programming	3	11th Dec 2006 05:14 AM
My customisation battle with xp continues - apply icon to all sub-	=?Utf-8?B?QnJhaW4=?=	Windows XP New Users	1	20th Apr 2006 03:20 PM
run code on opening workbook and apply code to certain sheets	=?Utf-8?B?SmFuZQ==?=	Microsoft Excel Programming	7	8th Aug 2005 09:15 AM
The line color icon is grayed out how can I change it to apply a .	=?Utf-8?B?YWxieW9uZQ==?=	Microsoft Frontpage	2	24th Sep 2004 11:17 PM