PDA

View Full Version : Solved: Prohibit or restrict copy



coliervile
07-23-2007, 05:21 PM
Is it possible to have a VBA code that prohibits/restrict someone from copying a workbook, file, worksheet(s)?

Best regards,

Charlie

unmarkedhelicopter
07-24-2007, 01:56 AM
Only at the most basic level.
It will not stop someone who can access protected code and remove you restriction and even more basic, anyone you chooses not to run macros on your workbook.
If you want to stop copying then look to creating pdf's

coliervile
07-24-2007, 02:26 AM
unmarkedhelicopter thanks for responding. In your statement "If you want to stop copying then look to creating pdf's" what is pdf's?

Best regards,

Charlie

daniel_d_n_r
07-24-2007, 03:21 AM
Adobe Acrobat Format .pdf file

coliervile
07-24-2007, 06:26 AM
In order to do so you need Adobe Acrobat Writer? Is there a web page to download a writer for FREE?

Best regards,

Charlie

unmarkedhelicopter
07-24-2007, 09:02 AM
No, but there are free alternates, though I'm not sure what the protection options are on the freeware/shareware/trialware alternates.

Try typing "pdf create free" into a search engine.
I know of :- PDF writer and Nova PDF as at least 2 examples

Charlize
07-24-2007, 03:28 PM
Try PDFCreator. Can be controlled from excel, word, ... and I believe Ken Puls (sorry if I'm wrong) has some examples on his site on how to control this program using excel, word ...

coliervile
07-24-2007, 06:09 PM
Thanks Charlize for the information, I'll take a look at it.

Best regards,

Charlie