Protection

  • Thread starter Thread starter robzrob
  • Start date Start date
R

robzrob

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.
 
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).
 
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 -
Click to expand...

Thanks very much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
can hidden sheets be prevented from opening without a password? 2
Userinterfaceonly 5
allow a user to edit ranges in a protected worksheet 3
Copy protection from one worksheet to another 2
Worksheet Protection / Security from Viewing 1
Password protected macro 3
Excel Move or Copy Stopped Working? 0

Back
Top