Spreadsheet help --

  • Thread starter Thread starter SaraHall :)
  • Start date Start date
S

SaraHall :)

How do I make a spreadsheet so that it is read only to everyone but one user
who also needs the ability to make changes to spreadsheet as necessary.


Thanks,
Sara
 
Protect it with a password, then let the user know the password and when she
is done ask her to protect it again

tools>protection>protect sheet

--


Regards,


Peo Sjoblom
 
Wow...that was really easy. It's pretty clear that I am new at this. Thank
you soo much
 
And be aware that Excel's internal security is very weak.

Anyone with access to the Internet and/or these newsgroups can find password
crackers in a heartbeat.


Gord Dibben MS Excel MVP
 
Back
Top