Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Norman Jones. It worked great. This was my first time in this
discussion group, I am so excited about having another avenue for information. Aardvark "Norman Jones" wrote: Hi Aardvaak, Try: Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim Res As Long Res = MsgBox("Have you...", vbYesNo) Cancel = Res < 6 End Sub This is workbook event code and should be pasted into the workbook's ThisWorkbook module: Right click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) | Select View Code from the resultant menu, and paste the code. Alt-F11 to return to Excel.. --- Regards, Norman "Aardvark" wrote in message ... On Excel XP I would like for a message box to come up when exiting a spreadsheet as a reminder to check certain items. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Dialog Box Macro for Excel | Excel Discussion (Misc queries) | |||
Excel Spreadsheet Not Saved Dialog Error | Excel Discussion (Misc queries) | |||
custom views dialog box | New Users to Excel | |||
Excel custom function dialog | Excel Worksheet Functions | |||
How can I make Excel display a message (dialog box) upon opening a spreadsheet? | Excel Discussion (Misc queries) |