Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change the size of vertical scroll bar | Excel Discussion (Misc queries) | |||
Assigning VB to Grouped Objects | Excel Discussion (Misc queries) | |||
How do I make excel hide columns when it says cannot move objects | Excel Discussion (Misc queries) | |||
Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
Scroll the screen view with the scroll bar | Excel Discussion (Misc queries) |