Regarding Command Button

[andy-s]

Hi,
I'm using command buttons and the data filter function in one om my workbooks.

My command buttons are always moving when I use the filter function.

My question is: Is it possible to place a command button in a constant position (altitude/width) from the top of the sheet?

andy-s

 

[George J]

Don't have access to excel, but this should be along the right lines.

Add msoBarFloating to its position:
Application.CommandBars.Add("Button", Position:=msoBarFloating, temporary:=True)

Not used buttons for quite some time though.

 

[Ivan F Moala]

Hi Andy

1) Get into Design Mode
2) Right click command button
3) Select Format control
4) Select Properties
5) Select Don't move or size with cells