Is all of that (the graphic, command buttons, and text boxes) too much to
allow you simply to make row 1 taller and put them up into it so that they
remain above the freeze line and still have usable space on the screen to
work with? This would also go along with unmerging all of those rows in
column G before resizing row 1.

Or consider some layout change options such as moving the command buttons
over into other columns (A-F) to provide more room in G without having to
make row 1 quite so tall? - Might consider moving them up above text in
those cells after increasing the row height?

Another option: consider putting those controls, text boxes, graphic onto a
UserForm and just put a button in G1 that does a UserForm1.Show operation,
bringing the form with the helpful information into view no matter where you
are in the workbook. Label the button in G1 with something like "Show
Detailed Help" or whatever seems more appropriate?


" wrote:

I have entries in rows under columns A, B, C, D and E. Pretty much a
normal sheet. Eventually, when I get to row 25 or 30, the page is going

to start scrolling down to show new rows.

Column G, at the right of the screen, is wider and its rows are merged
down all the way to infinity, or there abouts. Column G contains a
CommandButton, 2 text boxes and a gif which is a hyperlink to a Help
file.


Is there a way to keep those objects, in column G, displayed where they

are, in a static position (relative to the viewer), so when the sheet
begins to get long we don't have to scroll to the top to get to them?

I already have the headings at the top of A thru F on Freeze - works
fine. But, the merged column, G, I think needs to be done a different
way. I can't figure it out.


Thanks
Johnnie


P.S. This project has come together really well thanks to the help I've

received from this group. If I can accomplish the above, it will be
finished.