Solved: Prohibit or restrict copy

[coliervile]

Is it possible to have a VBA code that prohibits/restrict someone from copying a workbook, file, worksheet(s)?

Best regards,

Charlie

[unmarkedhelicopter]

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]

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]

Adobe Acrobat Format .pdf file

[coliervile]

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]

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]

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]

Thanks Charlize for the information, I'll take a look at it.

Best regards,

Charlie