Teach Yourself Excel Lesson Freeze Panes - Freeze Panes

Using Excel2003, I have tried to freeze just the top row, and /or leftmost 3
columns as these have titles in. I have done this separately and together,
and in all cases Excel freezes the top half and the leftmost half of the
visible screen (top 15 rows, leftmost 7 columns).
I have also recorded this in a macro and viewed it. The VBA is only
selecting the row / column(s) I selected i.e.
Range("1:1").Select
ActiveWindow.FreezePanes = True
Range("A:C").Select
ActiveWindow.FreezePanes = True
Running this leads to the same result.
Any help please.

Hi -

I'm writing an application in Excel and it has a logo at the top in a worksheet where I need the columns frozen for scrolling using freeze panes. Trouble is, the freeze pane line splits the logo in the screen shot below. Is there a way to turn off the freeze panes line?





- Bill

Is it possible to freeze only columns A through K?

Thanks.

Working on 60+ Worksheets within one workbook.

Is it possible to free Worksheet tabs the same wy you would freeze panes?

Hi,

I'm trying to get one of my macros to freeze panes in several worksheets.

For some reason though, sometimes it freezes the panes in the wrong place. What could be causing this?

My code basically looks like this:

Code:

                wbtemp.Worksheets("ActionItem").Activate
                wbtemp.Worksheets("ActionItem").range("B2").Select
                ActiveWindow.FreezePanes = True
                wbtemp.Worksheets("CARPAR").Activate
                wbtemp.Worksheets("CARPAR").range("B2").Select
                ActiveWindow.FreezePanes = True
                wbtemp.Worksheets("ECN").Activate
                wbtemp.Worksheets("ECN").range("B2").Select
                ActiveWindow.FreezePanes = True
                wbtemp.Worksheets("FCB").Activate
                wbtemp.Worksheets("FCB").range("B2").Select
                ActiveWindow.FreezePanes = True
                wbtemp.Worksheets("LDP").Activate
                wbtemp.Worksheets("LDP").range("B2").Select
                ActiveWindow.FreezePanes = True

Hi

I have recently installed Office 2007 and I am getting problem when I protect sheets, freeze panes do not work it is disable in excel 2007 and if I open same protectd worksheet in excel 2003 it is enable and works could any one tell me freeze panes work in execl 2007 in protected sheets.

hi , I am creating a utility in excel 2007 for managing the travel info for my personal usage. I have created different data tables in the same work sheeets and applied the filter on those tables. My whole intention is, when i select any of the item from the filter drop down i should be able to calculate the cost per person. The problem here i am facing is, when i select any of the item( i mean filter down), the other tables are affected by adding or deleting of its rows. I am not able to freeze the top row of each table.

Could you please help me in solving this mystery?

I have attached the worksheet sample(Sample.xlsx) which i am working on.

Best Regards,
Vijay

Hi All,

What am i doing wrong, i am trying to freeze pane (column 0 but Row 44) but i cant seem to do it, can you please advise where i am going wrong

Thanks

I cannot find the Window in the toolbar on which I can freeze panes, i.e.,
freeze column heads to prevent their scrolling out of view.