Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
FREEZE PANES | Excel Discussion (Misc queries) | |||
Freeze Panes? | Excel Discussion (Misc queries) | |||
Freeze panes | Excel Discussion (Misc queries) | |||
freeze panes | Excel Worksheet Functions |