Is there a way that I can 'lock' a sheet to prevent users from scrolling to
the right or down the page? I'd like to keep them on the form I've created
and not let them move to the right or down at all.
thanks
~cr
Is there a way that I can 'lock' a sheet to prevent users from scrolling to
the right or down the page? I'd like to keep them on the form I've created
and not let them move to the right or down at all.
thanks
~cr
If you hide all columns to the right and all rows below, the user can only
move around within the visible cells. You would need to protect the worksheet
so that can't change the hidden status.
On Wed, 5 Oct 2005 11:46:09 -0700, cindee <[email protected]>
wrote:
>Is there a way that I can 'lock' a sheet to prevent users from scrolling to
>the right or down the page? I'd like to keep them on the form I've created
>and not let them move to the right or down at all.
>
>thanks
>
>~cr
Tools | Protect Sheet (and limit users to selecting "Unlocked" cells only)
Make sure you've formatted the cells they're allowed to edit to "Unlock"
them...
"cindee" wrote:
> Is there a way that I can 'lock' a sheet to prevent users from scrolling to
> the right or down the page? I'd like to keep them on the form I've created
> and not let them move to the right or down at all.
>
> thanks
>
> ~cr
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks