(Solved) – Can an Excel macro assigned to a shape format the cell the shape is sitting on?

(solved)-–-can-an-excel-macro-assigned-to-a-shape-format-the-cell-the-shape-is-sitting-on?

I want to treat a column of cells as buttons where you click one and its font/fill change to show it is selected and formatting clears from the other “buttons”. It would seem that dropping rectangles on each cell and assigning them to some cell_on macro would do the trick, but I do not know how to make the macro reference the underlying cells dynamically. Using ActiveCell does not work because when clicking on an overlaid shape the cell beneath is not actually selected.

Leave a Reply

Your email address will not be published. Required fields are marked *