Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo Box selection to place $0 into another cell | Excel Discussion (Misc queries) | |||
remove text that pops up with combo box | Excel Worksheet Functions | |||
Variable control tip text | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Combo Box - Text Size | Excel Discussion (Misc queries) |