Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze objects in column with merged rows
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze objects in column with merged rows
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze objects in column with merged rows
JLatham wrote: 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. There are 3 worksheets. Column G text boxes are instructions on how to use each one and has to be visible in each sheet. The gif is a hyperlink to a help file and the CommandButton is a large Print Button. Many persons using the computer are not computer literate. Big things, clearly described and obvious to use is the rule for this one. It is for the security guards, some of whom have strong computer skills and some who have none. They type a pass number, its expiration date, the resident's name and the visitors' name, click the big Print Button and the printer prints it in the proper place on passes with lots of cutesy stuff already printed on them. I guess I'll just have to add CNTR+HOME to the directions......haha. Thanks Johnnie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze objects in column with merged rows
wrote: JLatham wrote: 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? You were right. I redesigned the whole thing and it even looks better. However, now I have a new problem. The date won't format as a date. I did it the same way I did on the old one. Please look at www.digitalbirdcrap.com/pass.html I Print Screened the page and pasted it there to show the problem. Thanks Johnne |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze objects in column with merged rows
JLatham wrote: 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. Yep! Thanks. I redesigned it.... works fine and looks better. Johnnie |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze objects in column with merged rows
Because you're using the OFFSET() to get the date into that merged cell at
K15:... it doesn't pick up the formatting from the source cell in column B. Fix should be easy, just click in the merged cell there at K and format it as a date separately. " wrote: wrote: JLatham wrote: 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? You were right. I redesigned the whole thing and it even looks better. However, now I have a new problem. The date won't format as a date. I did it the same way I did on the old one. Please look at www.digitalbirdcrap.com/pass.html I Print Screened the page and pasted it there to show the problem. Thanks Johnne |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze objects in column with merged rows
JLatham wrote: Because you're using the OFFSET() to get the date into that merged cell at K15:... it doesn't pick up the formatting from the source cell in column B. Fix should be easy, just click in the merged cell there at K and format it as a date separately. Wanna hear something funny..... for some reason, I woke up last night and that popped into my mind. I went in and turned on the computer..... brought up the sheet... sure enough, I hadn't formated the K cell for date. .....how embarrassing is that? ----haha! Thanks again Johnnie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |