Excel VBA forms on Intranet

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

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
 
Thanks for that - it wasn't quite what you said but it did put me on the
right track - it now works

Thanks again
 
Back
Top