Can I make a text box stay on screen every time I scroll up or down? I would
like to build a spreadsheet that would have several hundred rows of
information. I want the users of this spreadsheet to color code each line
according to a given color legend. I would like for the legend to stay on
screen as they move to different areas of the worksheet so that they don't
have to continually scroll up to the top of the page. I don't want to use
freeze panes because the column headings for each area are different.

You can insert a few empty rows above the top of your database and use the
Freeze feature on those rows and it will not affect your column
headers........they will scroll right up under this area.......... Then you
can put your text box up there, and it will stay while you scroll below.

Vaya con Dios,
Chuck, CABGx3



"Rodman" wrote:

Can I make a text box stay on screen every time I scroll up or down? I would
like to build a spreadsheet that would have several hundred rows of
information. I want the users of this spreadsheet to color code each line
according to a given color legend. I would like for the legend to stay on
screen as they move to different areas of the worksheet so that they don't
have to continually scroll up to the top of the page. I don't want to use
freeze panes because the column headings for each area are different.

If your rules are straight forward, why not just the the users a macro to color
code all the rows at once by running that macro.

And then you'd only have to worry about the macro running--instead of users
reading/following/and executing your rules.

You may be able to use format|conditional formatting, too. Or even an event
macro that would luck in the background waiting for a change that it recognizes.

Rodman wrote:

Can I make a text box stay on screen every time I scroll up or down? I would
like to build a spreadsheet that would have several hundred rows of
information. I want the users of this spreadsheet to color code each line
according to a given color legend. I would like for the legend to stay on
screen as they move to different areas of the worksheet so that they don't
have to continually scroll up to the top of the page. I don't want to use
freeze panes because the column headings for each area are different.

--

Dave Peterson