Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Panes with Object Model
Is the Excel application.Visible?
Is the workbook visible? Workbooks("Book1.xls").Windows(1).Visible = True Workbooks("Book1.xls").Activate Worksheets("Sheet1").Activate Rows(1).Select ActiveWindow.FreezePanes = true Regards, Tom Ogilvy "John Renkar" wrote in message ... I am using Access to export a query to an Excel Workbook. I then need to format the workbook from Access. I am able to do everything I need except freexe the top row. The online help suggests using: Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activa te ActiveWindow.FreezePanes = True I get a run time error '438': Object doesn't support this property or method Is there another way to accomplish this? Thank you in advance John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
"Excel.Application" Object Model | Charts and Charting in Excel | |||
Does MS Query have an object model | Excel Programming | |||
Accessing the VBA project object model | Excel Programming |