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