VC use Excel?

W

woodcolt

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!
 
J

JLGWhiz

This is in VBA help file.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.FreezePanes = True
 
Top