VC use Excel?

  • Thread starter Thread starter woodcolt
  • Start date Start date
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!
 
This is in VBA help file.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.FreezePanes = True
 
who knows what VC dose?

JLGWhiz said:
This is in VBA help file.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.FreezePanes = True
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Date Setting 1
Trying to freeze heading rows on a sheet 5
Which references will I need to reinstall on a new machine? 1
Online Help on VBIDE 3
Running Excel 12.0 Application on Office 2003 2
Unable to Authorize Launch Permissions for missing "Microsoft ExcelApplication" in DCOM Config 0
Help! Problem Referencing Excel 2003 in VB.NET 1
Excel 2003 to 2007 Migration Question 1

Back
Top