FreezePanes from VBA?
What are you expecting to happen ?
Are the Panes alraedy frozen ?
NickHK
"G Lykos" .gbl...
Greetings! Not understanding what I'm seeing. I'm creating an Excel
workbook from MS Project VBA, then formatting a worksheet in it and
exporting data to it. I want to freeze the pane, and captured the steps
below in a macro from within Excel, then inserted it into the Project sub.
Problem: when the MS Project sub executes, the Select below executes and
the worksheet responds, and the True line below executes but the worksheet
doesn't respond.
'Freeze
Range("F5").Select
ActiveWindow.FreezePanes = True
Any ideas why this doesn't work?
Thanks,
George
|