Aug 03 2022 01:48 PM
I'm running Excel on a Mac (macOS Monterey, ver 12.5). I'm adding checkboxes to my spreadsheet but cannot find a way to adjust the size of the checkbox itself. The Move and size with cells is grayed out (Format Object/Properties/Move
Aug 03 2022 10:20 PM
@JTJeT2 Right-click (or two-finger-click on the touch pad) on the checkbox. That will display the handles to adjust the size with.
I guess that once you have set the size of the box, you may want it to move with cells or anchor it in a fixed location on the sheet, but you wouldn't want the box to change shape/size when you re-size or insert rows/columns. That's why "move and size" is greyed out.
Aug 04 2022 10:29 AM
Aug 04 2022 01:40 PM
Thank you@Riny_van_Eekelen - I tried the right click and then adjusting by the grab handles. This adjusts the size of the box and whatever text is in the box. But it doesn't adjust the size of the checkbox itself. I was trying to change the size of the checkbox only because the checkmark is so small it's hard to see. A colleague suggested I use Google Sheets so I'll try that instead.
Aug 04 2022 01:42 PM
Aug 04 2022 01:56 PM - edited Aug 04 2022 01:57 PM
Hi again,
Changing font size and characteristics is pretty much the same across the board. If you use a font character you can control its size and color very easily.
You can probably use a cell formula or conditional formatting to turn the check box on or off. You probably don't need a macro at all.