Thread: Check Boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Check Boxes

Hi,

Here's a neat trick. If the checkboxes are from the 'Control' toolbox then
they must be in design mode.

Enable the 'drawing' toolbar "View|Toolbars" and you'll see a white arrow.
Drag a box around all the checkboxes and they become selected. then on the
drawing toolbar click:-

Draw|Align or distribute and then whichever alignment you want.

Mike



"doss04" wrote:

I've read many of the post regarding check boxes and have tried some of the
macros. I still cant seem to line up multiple boxes evenly. I end up zooming
to 200 and manually doing it. I've even tried the draw tab to align, but only
get one way.