Help Clicking Current Selection via VBA

Hey Everyone,

I have a sheet with about 200 buttons, each have been named AND have different macros.

I have a dynamic table on another sheet with a "Master Button". When you click on the "Master Button", I have a macro that selects 1 of the 200 buttons based off of the current selected location cell.

It works very well at moving to the appropriate sheet and selecting the correct object BUT

1) I can't figure out how to click that selected object via VBA.

2) I only want the macro to run if
--A) The selected cell has a value OR
--B) The user has only one cell selected within range C5:C600

Here is my code:

Please Login or Register  to view this content.

I will attach my workbook so you can see exactly what I am dealing with. Let me know if you need any more details.

Thank you all in advance

As you have named the buttons you could use application.caller to get the name of the shape and then create a object reference.

If you then did the same on the map, name the textboxs with same room reference, you could get away with 2 routines to get the room and then position the pointer