Commandbutton in a sheet?

Todd_M · Mar 1st, 2002, 12:46 PM

Hi-
I inserted a commandbutton in the bottom left hand corner of my excel sheet. Every time I scroll down or to the right, the button moves w/ it. How can I mke the button "float" on the sheet, but not move when I scroll?

lenze · Mar 1st, 2002, 01:20 PM

Instead of using a command button on your sheet, place it on a custom toolbar and attach the toolbar to the Workbook. The Toolbar will float as you scroll.

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

Mar 1st, 2002, 12:46 PM	#1
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Hi- I inserted a commandbutton in the bottom left hand corner of my excel sheet. Every time I scroll down or to the right, the button moves w/ it. How can I mke the button "float" on the sheet, but not move when I scroll?

Mar 1st, 2002, 01:20 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Instead of using a command button on your sheet, place it on a custom toolbar and attach the toolbar to the Workbook. The Toolbar will float as you scroll.