I have developed a form within Excel 2000 using VBA forms
which looks up names and parts of names within 1 of 3
worksheets - depending on the option chosen.

This works perfectly well when accessed via someones
desktop. However, once a link is placed to the file on the
intranet I get errors such as the one below

Method 'Worksheets' of object '_Global' failed

Can any one shed light on this and how to get around it as
all that I try creates another error and I end up trying
to fix that and losing focus on the real problem.

Any help very much appreciated

Thank you

Do you use the file name in the code? If yes, you'd better
change them to URL address.

Best Regards

Bill

-----Original Message-----
I have developed a form within Excel 2000 using VBA forms
which looks up names and parts of names within 1 of 3
worksheets - depending on the option chosen.

This works perfectly well when accessed via someones
desktop. However, once a link is placed to the file on
the
intranet I get errors such as the one below

Method 'Worksheets' of object '_Global' failed

Can any one shed light on this and how to get around it
as
all that I try creates another error and I end up trying
to fix that and losing focus on the real problem.

Any help very much appreciated

Thank you
.

Thanks for that - it wasn't quite what you said but it did put me on the
right track - it now works

Thanks again


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!