Reminder Macro

H

Help IN

I need to setup something to remind me to check a clolumn when I go to save a
worksheet. I am not sure if a macro is the best way to go about this. I
basically need a box to pop up when I hit save to say checselected column.
Can someone help me do this. I f I use a macro can you walk me through it?
Thanks
 
J

Jim Thomlinson

You need a macro for something like that. Right click on the XL icon in the
top left of the screen beside File in the menu. Select View Code. The VB
editor will open. Paste the following...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If MsgBox("Did you remember to check the selected column?", _
vbYesNo, "Column Check") = vbNo Then Cancel = True
End Sub

Before a save operation is completed it will as you if you check the
selected column. If you answer No then it will abort the save...
 
J

John Bundy

It looks like my last post was 'lost'.
Hit alt+F11, then ctl+R to bring up the project window, it should be on the
left and contain icons showing your sheets and a This Workbook icon,
double-click the ThisWorkbook icon and paste this there
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox "Check Column F"

End Sub
keep in mind that this will still save, repost if you want to verify before
you save and not save if you didn't verify.
 
Top