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