Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macros
I have multiple objects (ovals) in one column of a spreadsheet. I am able to
create macros with corresponding buttons that once clicked, will change the color of the first oval to either red, yellow, or green. I want these macros to apply to any of the objects in the column. Thus, I want to be able to click on any object in the column and then click the corresponding macro button that will change the color of the object to that which is desired. How do I set the macros so that they do not just apply to the first oval object, but that I can run them on any of the objects? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect macros? | Excel Discussion (Misc queries) | |||
sharing macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |