[AccessD] Freeze Panes

Charlotte Foust cfoust at infostatsystems.com
Fri Mar 2 12:46:17 CST 2007


Off the top of my head, shouldn't it be ActiveSheet?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Friday, March 02, 2007 10:20 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Freeze Panes

Dear List:
 
I am trying to do a Freeze Panes on an Excel spreadsheet I create in an
access app.  But I can't seem to get the code right.  I'm using:
 
    objXLS.Range("B2").Select
    objXLS.ActiveWindow.FreezePanes = True

but the compiler doesn't like ActiveWindow, says Method or Data Member
not found.
 
There's a bunch of other formatting that's working OK.  Mostly cribbed
from recording macros in Excel.
 
Does anyone know offhand the correct syntax for freezing the panes?
 
MTIA
 
Rocky
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list