Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
bob bob is offline
external usenet poster
 
Posts: 16
Default freeze panes

i have the following code assigned to a button to take me to A1 but the
freeze panes function used on a table of data will not let me goto A1. how
do i override freeze panes

ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1

thanks


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default freeze panes

Try like this:

Range("A1").select



Abdul Salam


-----Original Message-----
i have the following code assigned to a button to take

me to A1 but the
freeze panes function used on a table of data will not

let me goto A1. how
do i override freeze panes

ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1

thanks


.

  #3   Report Post  
Posted to microsoft.public.excel.programming
bob bob is offline
external usenet poster
 
Posts: 16
Default freeze panes

problem solved
"bob" wrote in message
. ca...
i have the following code assigned to a button to take me to A1 but the
freeze panes function used on a table of data will not let me goto A1. how
do i override freeze panes

ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1

thanks




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 freeze panes won't freeze top row only macbone2002 Excel Discussion (Misc queries) 3 April 22nd 23 02:07 AM
FREEZE PANES mjw Excel Discussion (Misc queries) 1 August 18th 09 05:30 PM
Freeze Panes? Ken Excel Discussion (Misc queries) 2 July 13th 09 06:32 PM
Freeze panes John Pryor Excel Discussion (Misc queries) 1 June 26th 06 03:55 PM
freeze panes Melissa Excel Worksheet Functions 3 July 13th 05 10:01 PM


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"