Protection

[robzrob]

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

 

[johnb49]

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.

 

[johnb49]

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]

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





- Show quoted text -

Thanks very much.