ExcelBanter - how do i freeze columns in excel 2000 ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do i freeze columns in excel 2000 ? (https://www.excelbanter.com/excel-programming/318206-how-do-i-freeze-columns-excel-2000-a.html)

Mitutoyo:)

how do i freeze columns in excel 2000 ?

Frank Kabel

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 ...

Rob

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:

All times are GMT +1. The time now is 01:13 AM.