Freeze Panes in Excel from Inside Project

S

Sannas

Hello,

I'm writing some code in MSProject and some of the reports it generates are
lengthy. I'm trying to freeze panes in Excel but cannot.
Below is what I'm trying...but to no use...Project gives me an error when I
try to execute. Any help would GREATLY be appreciated.

Rows("7:7").Select
ActiveWindow.FreezePanes = True

Thank you!

Sandra
 
S

Sannas

Save your fingers from typing! I figured it out. I approached it
incorrectly. I should have approached freezing panes through Page Setup.

Sandra
 
Top