LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default ActiveX Properties missing from menu

Hello,

Running xl2003 & xl2007.

I知 hoping someone can point out to me what I知 missing here.

I turn on the macro recorder, and add an ActiveX control to the
worksheet. I then right click on the control, and I see the
Properties & View Code menu items. As I壇 expect.

Sub Macro3()
ActiveSheet.OLEObjects.Add(ClassType:="Forms.Comma ndButton.1",
Link:=False _
, DisplayAsIcon:=False, Left:=143.25, Top:=59.25, Width:=96,
Height:= _
45.75).Select
End Sub

Now I run the above macro recorder code, and a new control is added to
the worksheet. But when I right click on this control, the Properties
& View Code items are missing. Why?

Thank you,

Regards,

DaveU


 
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
Definitions for Activex control properties? Blue Max Excel Worksheet Functions 2 December 17th 08 01:15 AM
How do I change activex control properties from a macro Billums Excel Discussion (Misc queries) 2 January 19th 06 01:21 PM
ActiveX properties in VB and VBA ヨrjan Leringe Excel Programming 2 August 15th 04 04:48 PM
ActiveX Control Properties Nigel Excel Programming 7 July 6th 04 07:08 AM
Return ActiveX properties by means of a variable??? true-blue Excel Programming 2 December 8th 03 05:40 PM


All times are GMT +1. The time now is 03:03 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"