ActiveX Command Button - Snap to Cell Boundaries

P

Paul Kraemer

Hi,

I am using Excel 2007. I have been placing several ActiveX Command Buttons
on a worksheet. I was wondering if there is a setting that would force the
boundaries of my Command Buttons to "snap" to cell boundaries on the
underlying worksheet.

Thanks in advance,
Paul Kraemer
 
D

Dave Peterson

Manually?

If yes, hold down the alt-key when you're positioning the commandbutton (or any
shape).

It'll snap-to the edge of a cell. Get close to the corner and it'll snap-to
both edges.
 
J

Jim Thomlinson

Nope but on the drawing toolbar you can Align Horizontal and Vertical as will
as space Horzontal and Veritical. Using a combinataion of those buttons you
can get things lined up pretty quickly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-line text on a CommandButton 3
How to use multiple command button to copy user form data to multiple worksheet 0
Command Button to show/hide a different worksheet 1
command buttons disappear when I move worksheet 2007 1
Force text to extend beyond cell boundaries 3
Userform Positioning 2
grouping Radio Buttons; Using ActiveX Controls 2
Assign Function to a Command Button 1

Top