I have 6 actions that need to be performed when a user clicks an object. I have 12 of these objects. Is there a way to write a function/routine/code block (I don't know what to call it) where I can place all 6 of these actions and then on each clickable oject just call this function/routine/code block to perform the actions?
So if one of the actions needs to change I have to change 12 different objects. That is what I should not have to do. I want to be able to change the "action" one time in one place and all 12 clickable objects then would be correct.
unfortunately You cannot define "Actions" outside objects, you could use macros but this is not a good choose.
However, if the 12 objects are all different (if it was possible to write all the actions in only a place) you have to write 12 different sequences of actions.
Building off Alessandro's suggestion, you should create the first object that has all of the actions and then rather than just copying and pasting, you should Copy and then right click --> Paste Sheet Object as Link.The two objects will then be linked together so a change in the action of one will impact the others (same holds true with general formatting as well).
