Is Microsoft Visual Basic For Applications Extensibility 5.3 an active
reference on all your machines?
--
Gary''s Student - gsnu200825


"Barb Reinhardt" wrote:

I have this line of code to find worksheets and it works on some systems and
not on others.

Set FindWorksheet =
myXLBook.Worksheets(CStr(myXLBook.VBProject.VBComp onents(myWSCodename).Properties("Name")))

I know that it won't work if the project is password protected, but in this
case, it's not.

Thanks,
Barb Reinhardt