R
robzrob
Can I password-protect a worksheet from viewing by all except the user
of that worksheet (on a shared workbook)?
of that worksheet (on a shared workbook)?
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.
J
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.
select format, row, row height, and entering zero. With protection "on" for
those rows, they cannot be reformatted to bring them back into view.
J
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).
"goto", for example A10:A100 in order to enter the default row height
(usually 13.00).
R
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.