Posted to microsoft.public.excel.programming

Zone[_3_]

external usenet poster

Posts: 373

assign macro to button programmatically

Many thanks and regards to Munich

"Helmut Weber" wrote in message
...
Hi Zone

Sub Macro1()
ActiveSheet.Shapes("Button 1").OnAction = "testB"
End Sub

--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 06:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us