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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Help IN" wrote:

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