Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a quick way to see which objects have code attached?
I have inherited a workbook with macros/visual basic
coding, that I need to make modifications to. Is there a quick way to see what the macros are attached to, other than right clicking on all of the excel objects, or individually selecting them in the vb editor? I'd like to see a listing of only the objects that have code attached to them, and what the name of the routine is called. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a quick way to see which objects have code attached?
Perhaps something like this:
for each shp in ActiveSheet.Shapes if shp.OnAction < "" then cells(rw,1).Value = shp.Onaction cells(rw,2).Value = shp.name rw = rw + 1 Next -- Regards, Tom Ogilvy "Terri" wrote in message ... I have inherited a workbook with macros/visual basic coding, that I need to make modifications to. Is there a quick way to see what the macros are attached to, other than right clicking on all of the excel objects, or individually selecting them in the vb editor? I'd like to see a listing of only the objects that have code attached to them, and what the name of the routine is called. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a quick way to see which objects have code attached?
Thanks for the tip -- I hadn't considered writing code to
find the objects. I'll try it! -----Original Message----- Perhaps something like this: for each shp in ActiveSheet.Shapes if shp.OnAction < "" then cells(rw,1).Value = shp.Onaction cells(rw,2).Value = shp.name rw = rw + 1 Next -- Regards, Tom Ogilvy "Terri" wrote in message ... I have inherited a workbook with macros/visual basic coding, that I need to make modifications to. Is there a quick way to see what the macros are attached to, other than right clicking on all of the excel objects, or individually selecting them in the vb editor? I'd like to see a listing of only the objects that have code attached to them, and what the name of the routine is called. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge from an attached word doc | Excel Discussion (Misc queries) | |||
Need to average with conditions attached | Excel Discussion (Misc queries) | |||
Quick Code | Excel Discussion (Misc queries) | |||
Accessing Attached XLS file | Excel Worksheet Functions | |||
Attached tool bars | Excel Discussion (Misc queries) |