Select a button on an active cell

Hi,

I would like to run a macro to hide/show a button that is on top of an active cell when another button is pressed. I want this to be a generic code for multiple button's, therefore I can't use a typical...

Please Login or Register  to view this content.

... because this requires a specific button name.

I think if I found a function that did the opposite of an Application.Caller, that would work. This would allow me to potentially select the button that lies on top of the active cell. However, I don't know if this function exists.

Does this function exist? Or is there another way to hide/show the button?

Please note that these buttons are from the "forms" toolbar.

Thanks!

Would iterating the Shapes and testing the Bottom Right Cell property work ?

Please Login or Register  to view this content.

when first creating set the sub as Public such that you can Assign it to your Master Button - then revert to Private so you can't invoke it from native XL other than via the Master Button(s) to which it is assigned (realistically)

the above would Toggle visibility - ie if cell button is visible it will be hidden, if hidden it will become visible etc...

edit: obviously if you ever upgrade to 2008 you have a problem

If I've understood - replace the visible toggle line with:

Please Login or Register  to view this content.