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

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.



"robzrob" wrote:

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

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).

"robzrob" wrote:

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

On May 18, 12:03*am, johnb49
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
(usually 13.00).



"robzrob" wrote:
Can I password-protect a worksheet from viewing by all except the user
of that worksheet (on a shared workbook)?- Hide quoted text -

- Show quoted text -

Thanks very much.