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

Look at the before_save event in the ThisWorkbook module.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Help IN" <Help wrote in message
...
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

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...
--
HTH...

Jim Thomlinson


"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

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