Regarding Command Button

andy-s · Apr 19th, 2002, 06:00 PM

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 · Apr 19th, 2002, 06:11 PM

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 · Apr 19th, 2002, 07:23 PM

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

Apr 19th, 2002, 06:11 PM	#2
George J Board Regular Join Date: Feb 2002 Location: Edinburgh, Bonnie Scotland Posts: 820	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. __________________ George J

Apr 19th, 2002, 07:23 PM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	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 __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 06:00 PM	#1
andy-s Board Regular Join Date: Mar 2002 Posts: 51	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