Freezing a Column on the Screen

[PaultheS]

I've got a bit of a problem with a form I'm creating in Excel with VBA.

On the left side of the form there's a column that defines the row (eg. a name). Then, for the next 15-20 columns the user is to input data. The problem is, by the time you get far over you can't see the first column anymore. It's pretty tricky to try to change one of the far right cells without scrolling back and forth a bunch of times.

Is there a way I can freeze one column so that it never scrolls off the left side? So that once you scroll right it just becomes (in effect) an extension of the row numbers?

If this solution isn't possible, then any suggestions for solving the problem are appreciated nonetheless.

 

[PaultheS]

I just found freeze panes, which sort of do the trick (assuming I can find code for them), but I'm not sure if I can freeze the column I'm looking for (the best one to freeze is around 4 columns out).

I'll reply again if I solve it.

 

[SkipVought]

Yes,

Window/Freeze.

The key is to position the screen display the way you want and then SELECT the cell to the right & below the columns/rows you want frozen.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[PHV]

assuming I can find code for them
Feel free to play with the macrorecorder.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PaultheS]

Thanks guys, I tried using the macro recorder and got the code I needed. Problem solved.