Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Button Position
I have 8 command buttons across the top 3 rows of my sheet. Anytime I resize
columns they move. Is there any setting I can place on them that they will hold their position I have their property's set to? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Button Position
If the Control Toolbox toolbar isn't activated, click VIEW in the menu,
select TOOLBARS and click on CONTROL TOOLBOX. Click the DESIGN MODE command button (pencil/triangle/ruler button) to activate design mode. Right click on each button and select FORMAT CONTROL. Click the PROPRERTIES tab and click the DON'T MOVE OR SIZE WITH CELLS option button and click OK. -- Kevin Backmann "Kenny" wrote: I have 8 command buttons across the top 3 rows of my sheet. Anytime I resize columns they move. Is there any setting I can place on them that they will hold their position I have their property's set to? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Button Position
thanks!
"Kevin B" wrote: If the Control Toolbox toolbar isn't activated, click VIEW in the menu, select TOOLBARS and click on CONTROL TOOLBOX. Click the DESIGN MODE command button (pencil/triangle/ruler button) to activate design mode. Right click on each button and select FORMAT CONTROL. Click the PROPRERTIES tab and click the DON'T MOVE OR SIZE WITH CELLS option button and click OK. -- Kevin Backmann "Kenny" wrote: I have 8 command buttons across the top 3 rows of my sheet. Anytime I resize columns they move. Is there any setting I can place on them that they will hold their position I have their property's set to? |
#4
|
|||
|
|||
Set each of the command button's properties to Don't Move or Size with Cells. Right click on the button and select Set Properties from the pop-up menu. I know this will work on buttons from the Forms menu. I don't know if the ActiveX controls from the toolbox have that option.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Command Button | Excel Discussion (Misc queries) | |||
How to add a command button | Excel Discussion (Misc queries) | |||
command button | Excel Worksheet Functions | |||
change position of filter button | Excel Worksheet Functions | |||
Command Button | Excel Discussion (Misc queries) |