ActiveX Command Button - Snap to Cell Boundaries

  • Thread starter Thread starter Paul Kraemer
  • Start date Start date
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
 
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.
 
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
Bottom boundaries of row headings 4
Assign Function to a Command Button 1
How to use multiple command button to copy user form data to multiple worksheet 0
Force text to extend beyond cell boundaries 3
Command Button to show/hide a different worksheet 1
Wrap Text doesn't work in Merged Cell 1
command buttons disappear when I move worksheet 2007 1

Back
Top