Posted to microsoft.public.excel.programming

Robin Hammond[_2_] Robin Hammond[_2_] is offline

external usenet poster

Posts: 575

Calling Com addin from form button on sheet?

Stephen,

Many thanks for such a comprehensive answer. I haven't had time to try it
yet, but now understand what I am aiming for at least.

Robin Hammond
www.enhanceddatasystems.com

"Stephen Bullen" wrote in message
...
Hi Robin,

Set clsBtnEvents.mcmdButton =
Wb.Worksheets(1).Shapes("btnStart").Object

That would need to be:

Wb.Worksheets(1).Shapes("btnStart").OLEFormat.Obje ct.Object

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

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
Calling addin Function from another workbook?	thinkingfield[_8_]	Excel Programming	1	November 11th 04 03:39 AM
Problem with calling Excel2000 addin in ExcelXP	wojtek	Excel Programming	0	November 8th 04 11:39 PM
Calling a sub from a addin in vba	Roger[_9_]	Excel Programming	4	November 3rd 03 10:39 AM
Calling an Excel Addin from VBA	ABN	Excel Programming	2	July 31st 03 02:33 PM
Calling an Excel Addin from VBA	ABN	Excel Programming	0	July 31st 03 02:02 PM

All times are GMT +1. The time now is 11:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us