"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

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
>
>
>

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
> >
> >
> >