| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 freeze panes won't freeze top row only
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - Freeze panes | Excel Discussion (Misc queries) | |||
| Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
| External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
| Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
