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