Nick, I was expecting that the pane would be frozen, same as if I did the
same thing by hand. However, I step through the execution, and the cell is
selected, per below, but then the VBA freezepanes method has no effect.
This from VBA running in MS Project.

George


"NickHK" wrote in message
...
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