Print and save as restriction
 

Possible to prevent user from printing and save as

Print and save as restriction
 

Besides making the file readonly (which doesn't prevent SaveAs)
If they disable macros, then no.

If they don't, use the beforeprint and beforesave events. Lock all cells,
protect all sheets and don't allow selecting (but they can still take a
snapshot).

--
Regards,
Tom Ogilvy


"crapit" wrote:

Possible to prevent user from printing and save as

Print and save as restriction
 

Oh, which mean disable macro allow all normal function

"Tom Ogilvy" wrote in message
...
Besides making the file readonly (which doesn't prevent SaveAs)
If they disable macros, then no.

If they don't, use the beforeprint and beforesave events. Lock all cells,
protect all sheets and don't allow selecting (but they can still take a
snapshot).

--
Regards,
Tom Ogilvy


"crapit" wrote:

Possible to prevent user from printing and save as