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
|