Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Sheet protection problem | Excel Discussion (Misc queries) | |||
Sheet protection error msg - Unrequested sheet activation | Excel Programming | |||
sheet protection problem | Excel Programming |