| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear button | Excel Discussion (Misc queries) | |||
| clear button | Excel Discussion (Misc queries) | |||
| Clear Button | Excel Discussion (Misc queries) | |||
| Using control to clear spreadsheet | Excel Discussion (Misc queries) | |||
| Clear and control the Office clipboard in Excel | Excel Programming | |||
Linear Mode
