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