H
Helmut Meukel
Hi,
I'm new to this group.
From a VB6-Program I create a new workbook with 1 worksheet.
After writing the title row I want to set the first column and the first
row non-scrollable. This is my actual code in the VB6 program:
ws.Range("B2").Select
ActiveWindow.FreezePanes = True
I tested it, it works.
My Question: is there another way to do this WITHOUT selecting
the cell first? Doing it with an non-active window?
I've searched to no avail, but probably haven't asked the right questions
or used the correct terms. (English isn't my first language).
TIA,
Helmut.
I'm new to this group.
From a VB6-Program I create a new workbook with 1 worksheet.
After writing the title row I want to set the first column and the first
row non-scrollable. This is my actual code in the VB6 program:
ws.Range("B2").Select
ActiveWindow.FreezePanes = True
I tested it, it works.
My Question: is there another way to do this WITHOUT selecting
the cell first? Doing it with an non-active window?
I've searched to no avail, but probably haven't asked the right questions
or used the correct terms. (English isn't my first language).
TIA,
Helmut.