Pop up reminder when closing Excel
Excellent - thanks Paul.
On Jul 2, 11:55*am, wrote:
Hi
With your excel file open:
Go to Tools, Macros, Visual Basic Editor
You will see your file name in the left hand window, with sheet names
and ThisWorkBook below it.
Double click ThisWorkBook
Paste in this code
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim Response As VbMsgBoxResult
Response = MsgBox("Did you do xyz?", vbYesNo, "Help saving your file")
If Response = vbNo Then Cancel = True
End Sub
Change as required.
regards
Paul
On Jul 2, 11:14*am, Gareth Wretham wrote:
I want to create a pop-up reminder which appears every time I go to
close Excel - reminding me to do xyz within the sheet - any idea how I
go about this?- Hide quoted text -
- Show quoted text -
|