protect a workbook to email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

have been trying to protect a spreadsheet to send out to Budget Responsible
Officers, I have followed the steps through the help menu and have protected
the sheets but as soon as they are e-mailed to someone else then the
protection has gone? How can I keep it protected from the recipient of the
e-mail once the file is e-mailed? i work with Excel 2000
 
have been trying to protect a spreadsheet to send out to Budget Responsible
Officers, I have followed the steps through the help menu and have protected
the sheets but as soon as they are e-mailed to someone else then the
protection has gone? How can I keep it protected from the recipient of the
e-mail once the file is e-mailed? i work with Excel 2000
Click to expand...

Short answer here is you can't. Protection on xl files is weak at best. Copy
and paste will often break it and if that doesn't work, there are many
useful password crackers out there that will.

If you don't want other to see something, don't send it to them :)
Will copy/paste special/values help you out here ? That will at least take
out the formulae.

HTH
 
have been trying to protect a spreadsheet to send out to Budget Responsible
Officers, I have followed the steps through the help menu and have protected
the sheets but as soon as they are e-mailed to someone else then the
protection has gone? How can I keep it protected from the recipient of the
e-mail once the file is e-mailed? i work with Excel 2000
Click to expand...
 
Back
Top