workbook before close

[bluepenink]

Hello

Im a newbie with macros so can someone pls help me with the
before close workbook macro

basically, i want to create a popup that says

"Have you confirmed the data?
Yes or No

if yes, then provide the normal save option etc
with a box for initials and check box to confirm?

if no, then go to sheet called "entry"

can someone pls help!

 

[pgc01]

Hi

Try the following:

Paste in the workbook module:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
 
If MsgBox("Have you confirmed the data?", vbYesNo) = vbNo Then
    Cancel = True
    Application.Goto Worksheets("Entry").Range("A1")
End If
End Sub

Please test.