Protecting a Spreadsheet

  • Thread starter Thread starter YZ
  • Start date Start date
Y

YZ

We are issuing more and more of our company quotes to customers simply by
e-mailing the spreadsheet that the calculations were made on.
Problem is that these also include our cost prices and mark-ups etc. which ,
obviously, we do not want the client to see.
I know that we can hide cells and protect the sheet but there are ways for
the client to beat that.

Any ideas on a way around this? Anyone else in the same situation?

TIA
Y.Z.
 
Y.Z.
I know that we can hide cells and protect the sheet but there are ways for
the client to beat that.
Click to expand...
And it's easier than you may think.

An option........
Place everything that you don't want the client to see on a separate worksheet.
Reference these values from the main sheet (the one that you would
normally send to the client.
Use something like Ron de Bruin's Add-In (or coding from his site) to
convert the formulas on the main sheet to values and mail only that
sheet to the client.

Ron's site is here:
http://www.rondebruin.nl/sendmail.htm

John
 
Back
Top