| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Excel FreezePanes from code
Dim xl As Worksheet
Set xl = Activesheet xl.Selection.Cells(2, 2).Activate() xl.ActiveWindow.FreezePanes = True -- Regards, Tom Ogilvy "lanem" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Excel FreezePanes from code
That did not help.
BTW, I'm doing this from ASP.NET 2.0 using VB.NET. Thanks anyway. "Tom Ogilvy" wrote: Dim xl As Worksheet Set xl = Activesheet xl.Selection.Cells(2, 2).Activate() xl.ActiveWindow.FreezePanes = True -- Regards, Tom Ogilvy "lanem" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems specifying where "freezepanes" occurs using VBA | Excel Programming | |||
| freezepanes | Excel Programming | |||
| do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
| stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Linear Mode
