Protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robzrob - 17 May 2008 12:27 GMT

Can I password-protect a worksheet from viewing by all except the user
of that worksheet (on a shared workbook)?

Reply to this Message

johnb49 - 18 May 2008 00:00 GMT

You can "hide" the data by selecting the range of rows you want hidden,
select format, row, row height, and entering zero. With protection "on" for
those rows, they cannot be reformatted to bring them back into view.

> Can I password-protect a worksheet from viewing by all except the user
> of that worksheet (on a shared workbook)?

Reply to this Message

johnb49 - 18 May 2008 00:03 GMT

By the way, to reformat those rows, you will need to enter the range in
"goto", for example A10:A100 in order to enter the default row height
(usually 13.00).

> Can I password-protect a worksheet from viewing by all except the user
> of that worksheet (on a shared workbook)?

Reply to this Message

robzrob - 25 May 2008 17:10 GMT

On May 18, 12:03 am, johnb49 <john...@discussions.microsoft.com>
wrote:

> By the way, to reformat those rows, you will need to enter the range in
> "goto", for example A10:A100 in order to enter the default row height
[quoted text clipped - 4 lines]
>
> - Show quoted text -

Thanks very much.

Reply to this Message