ExcelBanter - VC use Excel?

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

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

- - VC use Excel? (https://www.excelbanter.com/excel-programming/416335-vc-use-excel.html)

woodcolt

VC use Excel?

I use TypeLib include microsoft Excel 11.0 object library .Is there a way
to programatically freeze panes? I want my column headers to be locked rather
than scroll when scrolling the window down？I do not found
Excel.Window.activeWindow.FreezePanes in Cwindows or Cwindow0 class!

JLGWhiz

VC use Excel?

This is in VBA help file.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activa te
ActiveWindow.FreezePanes = True

"woodcolt" wrote:

I use TypeLib include microsoft Excel 11.0 object library .Is there a way
to programatically freeze panes? I want my column headers to be locked rather
than scroll when scrolling the window down？I do not found
Excel.Window.activeWindow.FreezePanes in Cwindows or Cwindow0 class!

woodcolt

VC use Excel?

who knows what VC dose?

"JLGWhiz" wrote:

This is in VBA help file.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activa te
ActiveWindow.FreezePanes = True

"woodcolt" wrote:

I use TypeLib include microsoft Excel 11.0 object library .Is there a way
to programatically freeze panes? I want my column headers to be locked rather
than scroll when scrolling the window down？I do not found
Excel.Window.activeWindow.FreezePanes in Cwindows or Cwindow0 class!

All times are GMT +1. The time now is 03:50 PM.