How do I automate "Freeze Panes" in Excel?
When I freeze panes in Excel, the macro recorder gives me:
ActiveWindow.FreezePanes = True
To what object should I apply the .FreezePanes property, when using Automation?
This.oSheet contains a reference to the current sheet, with which I work all the time.
I also have a property This.oExcel, as a reference to Excel.
I tried:
This.oSheet.FreezePanes = .T.
This.oSheet.Parent.FreezePanes = .T.
but both show error messages, in the sense that the property does not exist.
I also tried using This.oExcel.ActiveWindow, but it seems the property ActiveWindow doesn't exist.
TIA,
Hilmar
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)