|Thanks for your response DerbyDad03.|
Pop up to appear only on ABC.xls if i open it on or after 25/6/2011. The same 40 days rule may apply if i open ABC.xls on or after 25/6/2011
I have the following code which have demerits
Private Sub Workbook_Open()
Application.DisplayAlerts = False
If Date > DateSerial(2011, 6, 25) And .Path <> vbNullString Then
The demerits are:
1. All sheets are hidden and no new sheet can be inserted even before 25/6/2011 is reached.
2. I don't know how to add line(s) to appear pop up box on or after 25/6/2011 on which if correct password is entered the 40 days of extended life of ABC.xls may be achieved.