Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get the popup calendar to work when I protect the workbook
I have the following code in my workbook to bring up a calendar.
Private Sub Calendar1_Click() ActiveCell = Calendar1.Value ActiveCell.NumberFormat = "mm/dd/yy" End Sub Private Sub UserForm_Activate() Me.Calendar1.Value = Date End Sub When I choose a date on the calendar, I get the following message: Run-time error '1004' Unable to set the NumberFormat property of the range class If I choose End, the date appears in the cell. I want to publish this form on our website and don't want this message to appear. It only happens when I protect the worksheet. The date cell is unlocked. How do I fix? -- Patty |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Popup calendar | Excel Discussion (Misc queries) | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
calendar popup | Excel Discussion (Misc queries) | |||
Workbook Popup note | Excel Worksheet Functions | |||
popup calendar with multiple months | Excel Discussion (Misc queries) |