View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Works on some systems with Excel 2003 and not on others

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