MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Another odd question

Posted by David on August 01, 2000 2:39 AM

How do you end th sheet meaning I use 100 cell 10 down and ten over but the scroll bars think I use 10,000 how can i fix that?

Posted by JAF on August 01, 0100 7:10 AM

If you want to restrict the cells that a user can select, the following macro will do just that:
Sub auto_open()
Sheets("Sheet1").ScrollArea = "A1:J10"
End Sub

As this setting is not saved when the workbook is closed, so it must be assigned to an Auto_Open macro. To reset the scroll area, you would need the following:
Sub reset_scroll_Range()
Sheets("Sheet1").ScrollArea = ""
End Sub

Hope this helps.