Menu Item Property

T

tony

I am creating a symbol editor using VBA. I want to select item function from
different Default menus and add them to mine. I can get down to the .Action
property however I can not read the macro name assigned to this property even
though MSDN documentation declares (repeatly) that the .OnAction is a
read/write property. When I tryv to read the propertyvI get errors. Could
someone shed light on this please help.

Second I know that there is a way to hide a macro. I would like "unhide"
item macro --ie drawing a line -- and examine it. Possibly copy it modify it
for my purposes and resave as a user defined macro. Please Help

Tony
 
L

Leith Ross

tony;203642 said:
I am creating a symbol editor using VBA. I want to select item function
from
different Default menus and add them to mine. I can get down to the
.Action
property however I can not read the macro name assigned to this
property even
though MSDN documentation declares (repeatly) that the .OnAction is a
read/write property. When I tryv to read the propertyvI get errors.
Could
someone shed light on this please help.

Second I know that there is a way to hide a macro. I would like
"unhide"
item macro --ie drawing a line -- and examine it. Possibly copy it
modify it
for my purposes and resave as a user defined macro. Please Help

Tony
Click to expand...

Hello Tony,

Not all menu items have an OnAction property. Built-in menu items like
Copy, Paste, and Save have an ID property. Excel uses this to locate the
routine to execute when the item is selected. You can use these ID
numbers with custom menu items to invoke them. You can access the code
for the routines like a regular macro.


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
 
T

tony

I am talking about the drawing menu these menu items have .OnAction attribute
but I do not know what it is I cannot read the macro name.

How do you find out the codes for systems macro
 
L

Leith Ross

tony;204226 said:
I am talking about the drawing menu these menu items have .OnActio
attribute
but I do not know what it is I cannot read the macro name.

How do you find out the codes for systems macro


Ross' (http://www.thecodecage.com/forumz/members/leith-ross.html)
Click to expand...

Hello Tony,

You can not access the *OnAction* property because they are builti
menu items (system macros). Properties may be visible but not accessibl
depending upon the object

--
Leith Ros

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/
 
Top