[AccessD] Freeze Panes

Jim Moss jim.moss at jlmoss.net
Fri Mar 2 16:07:13 CST 2007


Rocky,

The .rows should come immediately before the freezepanes. I believe that
the compiler is getting hung up on your range statement

Jim

> Jim:
> The problem is the next line which won't compile.  So I can't even test
> the
> Rows statement. :(
>
> Rocky
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Moss
> Sent: Friday, March 02, 2007 12:03 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Freeze Panes
>
> Rocky,
>
> I think that you probably need a .rows statement before the freezepanes
> statement, like:
>  objSht.Rows("3:3").select or a columns if you aren't trying to freeze the
> sheet below the title line
>
> Jim
>
>> Charlotte:
>>
>> When I change the line to:
>>
>>     objXLS.ActiveSheet.FreezePanes = True
>>
>> Then I get the same error but on ActiveSheet instead of FreezePanes.
>>
>> Rocky
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
>> Foust
>> Sent: Friday, March 02, 2007 10:46 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Freeze Panes
>>
>> 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
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.5.446 / Virus Database: 268.18.5/707 - Release Date:
>> 3/1/2007
>> 2:43 PM
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.5/707 - Release Date: 3/1/2007
> 2:43 PM
>
>
> --
> 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