Lock Scroll Bar

[PRINCE21]

Is there a way to lock the scroll bar so users cannot move it around
the two scroll things on bottom of screen and on the right

 

[Peo Sjoblom]

You could have a macro that remove the scroll bars although a user could put
them back. In general it is a rather
bad idea to restrict things in excel

 

[Tom Ogilvy]

Look at the scrollarea property of the worksheet. Unfortunately, this needs
to be set with code, at least with xl2000 and xl97, since it is not retained
across the closing and opening of the workbook.

 

[Tom Ogilvy]

Are you selecting cells. If the cell selected has now moved lower in the
sheet because of previously added data, then this might be part of the
problem. You generally do not need to select cells in your code.

 

[Guest]

One workaround
You could hide all the columns and rows outside of the area you want people to see
Unlock all the cells you want them to be able to edit
Protect the sheet

Or, you could leave sheet protection alone, hide columns and rows as mentioned above, and protect the workbook structure

Both of these options would have side effects, but they would do what you are asking without code. A determined user could likely get around them--worksheet and workbook protection do not equal document security

tj