William, thanks for the suggestion, but - didn't help. Any other thoughts?

George


"William" wrote in message
...
Hi

Try this

ActiveWindow.FreezePanes = False
Range("F5").Select
ActiveWindow.FreezePanes = True
--

Regards

William

XL2003




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