[AccessD] Freeze Panes

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Fri Mar 2 12:19:41 CST 2007


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
 



More information about the AccessD mailing list