protect document

[Neil Greenough]

How do I protect a document, so that when I email somebody an invoice for
example, they cannot change any of the information on it?

Also, I have a column of numbers. Now what i'd like is to work out the
average of these numbers. Is it simply =AVERAGE(A1:A30) for example?

 

[Bob Flanagan]

Neil, on the invoice, get a PDF print driver (~$25) and then just create a
PDF file. Most PDF print drivers will let you make the PDF password
protected. I use the one from www.docu-track.com

And yes to your question on average.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Frank Kabel]

Hi
though you can use 'Tools - Protection' this kind of security is quite
weak. There's no secure way to protect your Excel files.

For your second question: Yes that simple

 

[Lady Layla]

WWW.PDF995.COM

Free if you dont mind ads, 9.95 if you do


: Neil, on the invoice, get a PDF print driver (~$25) and then just create a
: PDF file. Most PDF print drivers will let you make the PDF password
: protected. I use the one from www.docu-track.com
:
: And yes to your question on average.
:
: Robert Flanagan
: Macro Systems
: Delaware, U.S. 302-234-9857
: http://www.add-ins.com
: Productivity add-ins and downloadable books on VB macros for Excel
:
: : > How do I protect a document, so that when I email somebody an invoice for
: > example, they cannot change any of the information on it?
: >
: > Also, I have a column of numbers. Now what i'd like is to work out the
: > average of these numbers. Is it simply =AVERAGE(A1:A30) for example?
: >
: >
: >
: >
:
:

 

[Gord Dibben]

Build your own PDF Writer for free.

http://www.rcis.co.za/dale/info/pdfguide.htm

Works fine for me once set up.

Gord Dibben Excel MVP