tony;203642 Wrote:
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

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/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=55970