float Text and Combo box

S

stickandrock

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top