| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customized user exit warning/reminder
Is there anyway to customize a user exit warning/reminder to a workbook? For
example, "Did you verify volume and price?" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customized user exit warning/reminder
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim Msg, Style, Response Msg = "Did you verify volume and price?" Style = vbYesNo Response = MsgBox(Msg, Style) If Response = vbYes Then Exit Sub Else MsgBox "Do so now" End If Cancel = True End Sub Copy/paste into Thisworkbook module. To access that module, hit the Excel Icon left of "File" on menubar then "View Code" Paste into the module. Save the workbook then close. Gord Dibben MS Excel MVP On Tue, 15 Jul 2008 07:11:01 -0700, witsend wrote: Is there anyway to customize a user exit warning/reminder to a workbook? For example, "Did you verify volume and price?" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customized user exit warning/reminder
works like a dream! thanks so much!!!
rgds, witsend "Gord Dibben" wrote: Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim Msg, Style, Response Msg = "Did you verify volume and price?" Style = vbYesNo Response = MsgBox(Msg, Style) If Response = vbYes Then Exit Sub Else MsgBox "Do so now" End If Cancel = True End Sub Copy/paste into Thisworkbook module. To access that module, hit the Excel Icon left of "File" on menubar then "View Code" Paste into the module. Save the workbook then close. Gord Dibben MS Excel MVP On Tue, 15 Jul 2008 07:11:01 -0700, witsend wrote: Is there anyway to customize a user exit warning/reminder to a workbook? For example, "Did you verify volume and price?" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| Saving Print Settings - Customized for each user | Excel Discussion (Misc queries) | |||
| allow user to disable annoying warning dialog on log charts | Charts and Charting in Excel | |||
| Pop-Up Reminder | Excel Discussion (Misc queries) | |||
| How do I input a warning message to remind the user to enter into. | Excel Discussion (Misc queries) | |||
Hybrid Mode
