View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lanem lanem is offline
external usenet poster
 
Posts: 4
Default Help with Excel FreezePanes from code

I can't get this to work. Please help. Here's my code:

Dim xl As New Spreadsheet

xl.Selection.Cells(2, 2).Activate()
xl.ActiveWindow.FreezePanes = True

There's no errors . . . it just doesn't set up the FreezePanes stuff.