P
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
the two scroll things on bottom of screen and on the right
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
them back. In general it is a rather
bad idea to restrict things in excel
T
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.
to be set with code, at least with xl2000 and xl97, since it is not retained
across the closing and opening of the workbook.
T
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.
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.
G
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
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