| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i freeze columns in excel 2000 ?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i freeze columns in excel 2000 ?
Hi
e.g. - move the cursor to cell C1 - goto 'Windows - Freeze Panes' -- Regards Frank Kabel Frankfurt, Germany "Mitutoyo:)" schrieb im Newsbeitrag ... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i freeze columns in excel 2000 ?
Freeze Panes is on the Window menu.
If you want to do it with code then Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activa te Workbooks("BOOK1.XLS").Worksheets("Sheet1").range( "B2").select ActiveWindow.FreezePanes = True "Mitutoyo:)" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Excel sucks - cant freeze multiple rows & columns anymore | Excel Discussion (Misc queries) | |||
| Freeze multiple rows/columns in Excel 2007 | Excel Discussion (Misc queries) | |||
| Freeze Worksheet Tabs Excel 2000 | Excel Discussion (Misc queries) | |||
| Can I freeze column A and scroll down the other columns in Excel? | Excel Worksheet Functions | |||
| Freeze rows/columns in Excel | Excel Worksheet Functions | |||
Linear Mode
