| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Frozen columns"
Another useful command to move the cursor to the frozen corner is
Cells(ActiveWindow.ActivePane.ScrollRow, ActiveWindow.ActivePane.ScrollColumn).Select :) "Stefi" wrote: Hi Tim, If you want to freeze column A, then Range("B1").Select ActiveWindow.FreezePanes = True If you select C1, then columns A and B will be frozen, etc. Regards, Stefi €˛Tim Lypes€¯ ezt Ć*rta: Hello, I do not know the right ms teminologie for that. Maybe you know a column that is always visible inside a sheet even if the user scroll to the right site of the sheet. I want to set the "frozen" column programmatically with vb 2005 and office interop. I hope you know what I mean |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comments partially hidden due to "frozen" columns | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
| transpose the code from "rows" to "columns" | Excel Programming | |||
Threaded Mode
