View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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