float Text and Combo box
 

I have some combo and text boxes at the top of file. Based on the selection
of the combo I change the data displayed below this area. When I scroll down
the data the combo and text boxes scroll off also.

I want to be able to scroll through the data below and keep the combo boxes
floating on top (like as in freezing frames). I've tried to mess with
protecting the the sheet in combination with locking the objects, but that
stops me from editing the combi itself.

Any input would be greatly appreciated.

You can make row 1 pretty high.

Then put all your objects in row 1.

Then select A1 (to make sure it's visible)
then select A2
window|freeze panes

Now you'll always be able to see row 1.

stickandrock wrote:

I have some combo and text boxes at the top of file. Based on the selection
of the combo I change the data displayed below this area. When I scroll down
the data the combo and text boxes scroll off also.

I want to be able to scroll through the data below and keep the combo boxes
floating on top (like as in freezing frames). I've tried to mess with
protecting the the sheet in combination with locking the objects, but that
stops me from editing the combi itself.

Any input would be greatly appreciated.

--

Dave Peterson