View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sebastienm sebastienm is offline
external usenet poster
 
Posts: 694
Default Worksheet Scrolling

Hi
One way would be to set the ScrollArea property to say A1:J30. However this
property is cannot be saved with the book and is lost once the book is
re-open. That is, you would have to set it in the Workbook_Open sub of the
ThisWOrkbook module.
Another way would be to hide any other row and columns outside of the
'scrollable' rectangle; unlock the cells of that rectangle (menu Format
Cells, tab Protection); and finally protect the sheet.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Jason Zischke" wrote:

Hi All,

Is There a way to disable the srcolling on a worksheet os that a user can't
scroll on a worsheet?

Thanks in Advance

Jason