control button used to clear a sheet

[Arnie from Jasic]

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

[Tom Ogilvy]

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 [email protected]> wrote in
message news:[email protected]...
> how do i prevent users from clearing data via a control button if they
> haven't printed it yet? Matt. S.