Calendar problem with sheet protection?
 

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

Calendar problem with sheet protection?
 

See
http://www.rondebruin.nl/calendar.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"DORI" wrote in message ...

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

Calendar problem with sheet protection?
 

Thanks
Dori

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/calendar.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"DORI" wrote in message ...

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