Freeze top row in vba

[welchs101]

hi, i am trying to freeze the top row of a given worksheet. I recorded a macro to see how to do it and this is what it gives me.

Please Login or Register  to view this content.

I replaced the "activewindow" with

workbooks(fl_name).worksheets(1)

but it does not work.


So i used this

Please Login or Register  to view this content.

While this did work.........froze top row............but it also split the top row. So i could not simply unfreeze the top row.


Is there a better way to freeze the top row?

[welchs101]

i think i found a better way

Please Login or Register  to view this content.

i just selected the row below where i wanted to freeze it.

I would still like to know why i have to use activewindow and why i cant use an assignment like
"workbooks(jlkjkkljl).worksheet(jlj)" instead of activewindow.......

[OnErrorGoto0]

FreezePanes is a property of the window, not the worksheet.

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS

[Domski]

Try:

Please Login or Register  to view this content.

Dom

[welchs101]

thanks for the info and code.