Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ActiveX Command Button - Snap to Cell Boundaries
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 -- Paul Kraemer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ActiveX Command Button - Snap to Cell Boundaries
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. Paul Kraemer wrote: 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 -- Paul Kraemer -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ActiveX Command Button - Snap to Cell Boundaries
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. -- HTH... Jim Thomlinson "Paul Kraemer" wrote: 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 -- Paul Kraemer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to disable/enable command button(ActiveX) using macro | Excel Discussion (Misc queries) | |||
Command Buttons & ActiveX Controls | Excel Discussion (Misc queries) | |||
Command Buttons & ActiveX Controls | Excel Discussion (Misc queries) | |||
Getting an ActiveX command button to do a spreadsheet function | Excel Worksheet Functions | |||
Activex command to Hide/Unhide | Excel Worksheet Functions |