Posted to microsoft.public.excel.programming

Zone[_3_]

external usenet poster

Posts: 373

assign macro to button programmatically

I have a button on my worksheet from the Forms toolbar. I know I can use
ActiveSheet.Buttons(1).Caption="My Text" to set the button's caption. But
how do I set the button's macro to sub SpeakMsg? Excel XP. Thanks, James

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Assign a macro to a button	totofab	Excel Discussion (Misc queries)	4	December 13th 07 06:16 PM
How to assign a macro to a button	WANNABE	Excel Programming	2	October 2nd 06 08:25 PM
How do I Assign Macro to a button?	BellExcel	Charts and Charting in Excel	4	May 20th 05 07:21 PM
Assign macro to button	Bob Phillips[_6_]	Excel Programming	0	May 24th 04 04:27 PM
how to add code programmatically to a macro for a button	Tina	Excel Programming	0	August 26th 03 03:30 AM

All times are GMT +1. The time now is 05:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us