Popup alert for expiring date

[LepiMitar]

Hello my life savers!
How to set pop-up alert for expiring date in Excel2010. Like I have multiple Items and I only have producing date, but they all expire in 1 year, and I (my boss) would like to get notification one month before it expires. Something like that. Code I made only worked for the sheet where I was when I last time saved.

Please help me keeping my job

 

[footoo]

Perhaps use Conditional Formatting.
If the producing dates are in column A, use the following CF formula and the formatting of your choice :
=A1 < NOW()+30<now()+30< html=""></now()+30<>