Record a macro that unprotects the doc.
Record a macro that protects the doc.

Paste the unprotect code to the start of the Calendar code


Paste the protect code at the end of the calendar code.

So when the calendar is clicked, the code will unprotect, do the date, then re-protect.

I am trying to use the second calendar for a second date and as you mentioned I used 2 different texts for the dates which are

1. "EffectiveDate: "
2. "ExpirationDate:"

In this case only the first calendar works and the 2nd calendar is set to the first calendars date only when clicked.

How will I be able to overcome this.

Thank you !