Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons on Sheet moving with cells
Hey guys,
I am using the following code supplied by Nigel that autofits columns based on cell value. The problem is that my command buttons also move with the movement of the cells. How do I stop this? Worksheets("Sheet1").Columns("A:IV").AutoFit Thanx Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons on Sheet moving with cells
Todd,
In the Format Control dialog, choose the Properties tab and select either "Move but don't size with cells" or "Don't move or size with cells". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd Huttenstine" wrote in message ... Hey guys, I am using the following code supplied by Nigel that autofits columns based on cell value. The problem is that my command buttons also move with the movement of the cells. How do I stop this? Worksheets("Sheet1").Columns("A:IV").AutoFit Thanx Todd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons on Sheet moving with cells
Right click the command buttons and select Format Control
from the popup menu. Select the Properties tab and then select the option button "Don't move or size with Cells". Regards, Greg -----Original Message----- Hey guys, I am using the following code supplied by Nigel that autofits columns based on cell value. The problem is that my command buttons also move with the movement of the cells. How do I stop this? Worksheets("Sheet1").Columns("A:IV").AutoFit Thanx Todd . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons on Sheet moving with cells
Todd,
Save the position beforehand, and restore it afterwards. Something like Dim pos1 As Double With Worksheets("Sheet2") pos1 = .CommandButton1.Left .Columns("A:IV").AutoFit .CommandButton1.Left = pos1 End With -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Todd Huttenstine" wrote in message ... Hey guys, I am using the following code supplied by Nigel that autofits columns based on cell value. The problem is that my command buttons also move with the movement of the cells. How do I stop this? Worksheets("Sheet1").Columns("A:IV").AutoFit Thanx Todd |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons on Sheet moving with cells
Thanx, the format property worked well.
-----Original Message----- Hey guys, I am using the following code supplied by Nigel that autofits columns based on cell value. The problem is that my command buttons also move with the movement of the cells. How do I stop this? Worksheets("Sheet1").Columns("A:IV").AutoFit Thanx Todd . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command buttons linked to moving rows | Excel Discussion (Misc queries) | |||
Command Buttons on sheet changing sizes | Excel Discussion (Misc queries) | |||
Putting Command Buttons on a Chart Sheet | Charts and Charting in Excel | |||
Embedding command buttons in cells | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming |