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.
|