Restricting Print/Mail/Export on Sheet

Re: Restricting Print/Mail/Export on Sheet

I don't think this will be very easy and you might have to deal with these as separate subjects.

It is also quite difficult to balance the functionality you give to users against the security you build in.

Some ideas :-

To stop printing you could use the Workbook_BeforePrint event.

You should stop e mailing if you switch the protection on.

Stop copying - protection again.

Stop saving as - Workbook_BeforeSave event.

HTH

PS I am looking at Rights Management to control spreadsheets but you need to keep them on a server to do this.

Re: Restricting Print/Mail/Export on Sheet

Ok. Post back if you get problems.