I have an Button for this : to autofit columns, from 8 to....how many they are (found on net)
Dim x As Integer
For x = 8 To ActiveSheet.UsedRange.Columns.Count
Columns(x).EntireColumn.AutoFit
Next x
All Ok, it autofit columns but it change the SIZE too of my Active X Control buttons placed in these columns even they are set don't move or size with cells
How to fix this ?
Dim x As Integer
For x = 8 To ActiveSheet.UsedRange.Columns.Count
Columns(x).EntireColumn.AutoFit
Next x
All Ok, it autofit columns but it change the SIZE too of my Active X Control buttons placed in these columns even they are set don't move or size with cells
How to fix this ?
Last edited: