Set objects not to scroll
 

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?

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.

Set objects not to scroll
 

I may be wrong but I dont think its possible to do that. Userforms or
Inputboxs would get round this problem. You could place a button on the
frozen pane say at column A. You then scroll down the page, hit the button
and a userform pops up with the textbox's and other controls.

See link on how to create userforms.
http://www.contextures.com/xlUserForm01.html


" 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?

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.

Set objects not to scroll
 

Hi Johnnie

Your command button, textboxes and gif can't be that big, surely. Why not
just freeze the rows above row 15 (or however much rowspace the controls
take up)?

Best rgds
Chris Lav

wrote in message
oups.com...
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?

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.