Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop-up calendar with protected sheet
Dear All,
I was able to take all the great info from microsoft.public.excel.programming and create pop-up calendars in my Excel spreadsheet. The problem is that they wont function properly when I protect my worksheet. I keep getting the error shown below. Any advice? Run-time error '1004': Unable to set the NumberFormat property of the Range class |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop-up calendar with protected sheet
Have you read this on my site
http://www.rondebruin.nl/calendar.htm Note: If you protect your sheet in Excel 97-2000 then you must format the range first with the Date format you want and remove this line ActiveCell.NumberFormat = "mm/dd/yyyy" In Excel 2002 and 2003 you be able to protect your worksheet and allow Format cells. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... Dear All, I was able to take all the great info from microsoft.public.excel.programming and create pop-up calendars in my Excel spreadsheet. The problem is that they wont function properly when I protect my worksheet. I keep getting the error shown below. Any advice? Run-time error '1004': Unable to set the NumberFormat property of the Range class |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop-up calendar with protected sheet
Hi S,
Try protecting the sheet using the rtotect method's UserInterfaceOnly argument: in this way, the sheet will remain protected for the user, but VBA will be able to manipulate the sheet. However, this setting is not persistent and needs to be reset each time the workbook is opened. Perhaps, therefore, you could set protection in the Workbook_Open or Auto_Open procedures, e.g.: '============= Sub Auto_Open() With Worksheets("sheet1") .Protect Password:="drowssap", _ UserInterfaceOnly:=True .EnableAutoFilter = True 'Optional setting EnableOutlining = True 'Otional setting End With End Sub '<<============= --- Regards, Norman wrote in message oups.com... Dear All, I was able to take all the great info from microsoft.public.excel.programming and create pop-up calendars in my Excel spreadsheet. The problem is that they wont function properly when I protect my worksheet. I keep getting the error shown below. Any advice? Run-time error '1004': Unable to set the NumberFormat property of the Range class |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop-up calendar with protected sheet
Hi S,
EnableOutlining = True 'Otional setting Should read: .EnableOutlining = True 'Otional setting --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Information - Is sheet protected? | Excel Discussion (Misc queries) | |||
Calendar problem with sheet protection? | Excel Programming | |||
Protected sheet to unprotected sheet | Excel Worksheet Functions | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
put a calendar on an excel sheet | Excel Programming |