Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application-Defined error for some users...
I get the following error for my users in DC but my users in Baltimore
can run my program with no problem: 1004: Application-defined or object-defined error on line: Windows("IT Consolidated Calendar Event Request.xls").Activate ActiveSheet.Protect Password:="Disney", DrawingObjects:=True, Contents:=True, Scenarios:=True _ , AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True ActiveWorkbook.Save It happens on the Activesheet.protect line. Unfortunately I can't remote to PCs in our DC office and i REALLY don't want to have to go down there next week!! Thanks, Shelley |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application-Defined error for some users...
My first guess would be that the users in DC are using xl2000 or earlier.
Excel 2000 doesn't support all those options. xl2000 and earlier would be more like ActiveSheet.Protect Password:="Disney", _ DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True -- Regards, Tom Ogilvy "sbowman" wrote: I get the following error for my users in DC but my users in Baltimore can run my program with no problem: 1004: Application-defined or object-defined error on line: Windows("IT Consolidated Calendar Event Request.xls").Activate ActiveSheet.Protect Password:="Disney", DrawingObjects:=True, Contents:=True, Scenarios:=True _ , AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True ActiveWorkbook.Save It happens on the Activesheet.protect line. Unfortunately I can't remote to PCs in our DC office and i REALLY don't want to have to go down there next week!! Thanks, Shelley |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application-Defined error for some users...
Exactly the answer I needed...thanks!!!
Much Appreciated, Shelley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error 1004: Application defined or object defined error | Excel Programming | |||
Runtime error 1004- application defined or object defined error | Excel Programming | |||
Runtime error 1004- application defined or object defined error | Excel Programming | |||
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error | Excel Programming | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming |