Calendar problem with sheet protection?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have inserted a calender to a worksheet and I need to protect the sheet.
The calendar works ok when the sheet is unprotected but when I protect the
sheet, when I click on the date cell, the calendar appear and I can pick up a
date but it give an error like this:

Run-time error '1004':
Unable to set the NumberFormat property of the Range class

I have formatted the cell to show date dd/mm/yyyy. The calendar works ok but
this message is annoying. How can I get rid of this message?
Any help much appreciated.
Dori
 
Back
Top