View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
crapit[_2_] crapit[_2_] is offline
external usenet poster
 
Posts: 18
Default 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