Macro or VBA code to automatically center Checkboxes

[mattch91]

Hi,

Apologies to being an Excel/VBA/Macro newb. I manually entered checkboxes in by inserting them (without using VBA code). I am looking to automatically center the checkboxes so that even if someone adjusts the column or width of a row/column, the checkbox will automatically center as well. Is there a way to do this?

If I need to re-do how I entered the checkboxes in to begin with by using VBA code that is fine.

*If someone can help, please let me know if you can, step by step how to install the macro or enter in the VBA code. I am very new to this!!

I have added the document as an attachment for reference.

Thanks!

[jaslake]

Hi mattch91

I know of no way to do this "automatically" as no Event fires when Column Width or Row Height is changed. The best I can suggest is a Button that fires your existing Code when the User Clicks the Button.