control button used to clear a sheet
 

how do i prevent users from clearing data via a control button if they
haven't printed it yet? Matt. S.

control button used to clear a sheet
 

You would need to maintain a record of when they printed and if there have
been subsequent changes since then. You can use the beforeprint event to
detect that they are printing.

You can control the ThisWorkbook.Saved property to detect changes.

--
Regards,
Tom Ogilvy

"Arnie from Jasic" <Arnie from wrote in
message ...
how do i prevent users from clearing data via a control button if they
haven't printed it yet? Matt. S.