Msgbox code needs tweeked

[Richard]

This code works great and i can live with it. But can it
be tweeked with a VBYESNO msgbox that if you click YES
that you have posted your drafts, then it wont remind you
every day till the 15th. But NO will still remind you.
Private Sub Workbook_Open()
If Day(Date) >= 10 And Day(Date) < 15 Then MsgBox "Have
you posted your drafts for Golds Gym ($28.00) and NetZero
($9.95) for the 15th.!", 48, "Automatic Drafts Reminder"
End Sub
Thanks in advance!

 

[Dave Peterson]

You've got some replies at your other post.

This code works great and i can live with it. But can it
be tweeked with a VBYESNO msgbox that if you click YES
that you have posted your drafts, then it wont remind you
every day till the 15th. But NO will still remind you.
Private Sub Workbook_Open()
If Day(Date) >= 10 And Day(Date) < 15 Then MsgBox "Have
you posted your drafts for Golds Gym ($28.00) and NetZero
($9.95) for the 15th.!", 48, "Automatic Drafts Reminder"
End Sub
Thanks in advance!

 

[Richard]

Have you read my responses. End if, No end if, don't need
to know if or not i need an end if, whether it works or
not. Thats why i thought I'd give another group a chance.
Well guess not! Please just forget i mentioned anything!

 

[Frank Kabel]

Hi Richard
Gord Dibben gave you the suggestion:

-------------
Suggest you store the vbYesNo response in a cell or in the Registry.

Have your Workbook_Open check the value of that response.

If "yes" then Exit Sub. If "no" then show the message.

 

[Dave Peterson]

And if you split up your questions among several groups, you'll have to check
each post to find the best answer.

If you limit your question to one group, then followup there, you won't have to
waste your time and you won't waste time of people who respond to an already
solved problem.

And you have another post at your other thread (again).

(my post wasn't meant for only you. It was a warning to others so that they
wouldn't waste their time offering a similar solution.)