Thread: freeze panes
View Single Post
  #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