scroll area

  • Thread starter Thread starter fred ellam
  • Start date Start date
F

fred ellam

how to set the scroll area for a sheet
i.e the maximum numbers of rows/colums that can be
displyed on a sheet???
 
Fred, this will control the scroll area, will not let you select anything
past the area. Put in sheet code

Private Sub Worksheet_Activate()
ScrollArea = "a1:h25"
End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top