When you open the document a reminder popup will show for dates reached.

Good day all

Can someone please help me? I am using MS Office 2010 and I have attached the document here for an example of what I will be using.

When I open this document excel must give me a popup block telling me about the item I must be doing now since the popup must appear 14 days before the date is reached and then again on the date itself.

Please in the example I have attached there is only one tab in it. but in the document I am using there is multiple tabs, so I need it to give me the popup block (reminder) no matter on what tab I am opening the document on.

Do the following: Hold down the ALT key and press the F11 key. This will open the Visual Basic Editor. In the left hand pane, doubleclick 'ThisWorkbook'. Copy and paste the macro below in the empty code window that opens up. Close the window to return to your sheet. Save the file as an Excel Macro-Enabled workbook. Close the file and then re-open it.

Please Login or Register  to view this content.

Could you attach a copy of your actual file with all the sheets involved? Give a detailed step-by-step explanation of what you want to do. It is difficult to suggest a macro and test it without complete data.

Try this macro in the code module for ThisWorkbook:

Please Login or Register  to view this content.

I don't know why, but I had to remove all the conditional formatting to get this to work.

You are very welcome.

Can you attach a copy of the current file that is not working for you?

The reason that the macro appears not to be working is that the three dates you have in the "Reminders" sheet don't meet the criteria you requested.

• 28/02/2016: This date is more than 14 days before today's date.
  30/06/2016: This date is beyond today's date.
  30/09/2016: This date is beyond today's date.

The warning message appears only if the dates in the "Reminders" sheet are equal to today's date or up to 14 days before today's date.

You're welcome.