View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson[_4_] Greg Wilson[_4_] is offline
external usenet poster
 
Posts: 218
Default 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
.