Thread: VC use Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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!