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 |
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 . |
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 |
All times are GMT +1. The time now is 03:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com