View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Locking Data Sheet

Hi AJ,

yes it is possible, select the ws cells, right click, format cell -
protection - check both boxes Block and Hide.

Select Tools - and protect the sheet with one password.

but, have notice that the passwords are easy broken...

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"AJ" escreveu:

I would like to lock a data sheet so that no one can change my document but
me. I will be sending this document to an email account for viewing but I
don't want the view that have the option to change or either know my formular.

Is the possible? If so, what are the stepts?