i want to create a pop up window so when i x excel, it pops up like an error
message. so it says 'did you remember to update total of customers' with a
yes and return button. Please help me :D

Hi,

Alt + F11 to open vb editor. Double click this workbook and paste this in

Private Sub Workbook_BeforeClose(Cancel As Boolean)
msg = "Did you remember to update total of customers?"
response = MsgBox(msg, vbYesNo)
If response = vbNo Then
Cancel = True
End If
End Sub

Mike
"riley2007" wrote:

i want to create a pop up window so when i x excel, it pops up like an error
message. so it says 'did you remember to update total of customers' with a
yes and return button. Please help me :D

Do you mean when you close a particular workbook? If so, open the
VBE, select the ThisWorkbook module and place this:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If MsgBox("Did you remember to update total " & _
"of customers?", vbYesNo) = vbNo Then Cancel = True
End Sub

riley2007 wrote:
i want to create a pop up window so when i x excel, it pops up like an error
message. so it says 'did you remember to update total of customers' with a
yes and return button. Please help me :D

Hi
I am a real novice at this so I hope someone can help.
I am trying to use the above code to bring up a message when someone tries to close the workbook.
I can't get it to work.
I already have a module 1 so would you place this in module 2(which I have tried )
If someone could go through it step by step would be a great help.
The message that I want to come up is "Have you Protected the Sheets"
with the option to comfirm or return .

Cheers

Just managed to work it out
So I'm ok
Cheers