View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default 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