"Frozen columns"
 

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

"Frozen columns"
 

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

"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