Help! I'm completely lost on this one!!

I have an application that I've built in Excel and sent to a friend t
test in his business but although it runs perfectly on my deskto
(office 2000) and laptop (Office 2002) it won't run on ANY of his PCs.

The error message that comes up apparently says

Run-time error "1004"
Application-undefined or Object-undefined

The error appears to stop on the line "ActiveSheet.Protec
Password:=Sheets("sheet2").Range("w29").Value" in the following code:
-------------------------------------------------------------
Application.EnableCancelKey = xlDisabled
Calculate
ActiveSheet.Protect Password:=Sheets("sheet2").Range("w29").Value
Sheets("home").Visible = True
Sheets("Home").Select
Application.ScreenUpdating = False
etc etc
--------------------------------------------------------------

......but there are a number of lines like this which re-lock sheet
prior to going to a different worksheet using a randomly generate
number in cell W29

My friend has tried it on Office 2000 and Office 2003 on multiple PC
and always gets the same message, which I just can't recreate in m
office....and sending him a copy that works on mine....still won't wor
on his.

In Visual Basic Editor I can see that I have the following referece
checked, and as far as I can ascertain over the 'phone my friend ha
similar checked:

Visual Basic For Applications
Microsoft Excel 9.0 Object Library
OLE Automation
Microsoft Office 9.0 Object Library
Microsoft Forms 2.0 Object Library

I'm concerned that errors like this make Excel unreliable in running o
other PCs even when they are running the same apps as me.

Any help would be gratefully received.

Many thanks,

Chris

--
Message posted from http://www.ExcelForum.com