View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DORI DORI is offline
external usenet poster
 
Posts: 35
Default 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