View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Reynolds[_3_] Bob Reynolds[_3_] is offline
external usenet poster
 
Posts: 34
Default Header Row 1 is displayed in split screen - Way to keep

Hello,
I am using Excel as a database for a merge file and I have the screen split
so that Row 1 is always visible. However some of the people it's been
distributed to like to click in there and then it scrolls down, leaving them
without the headers. Is there anyway to permanently freeze this first row in
the split screen where they can't alter the display. I do need to have the
worksheet unprotected because of a couple of macro's running.
Thanks
BOB REYNOLDS