I have a program in Excel that I need to run on our Intranet. The use
will click on a link an the excel file will download to their compute
in their browser.

My program works great before uploading it, but when I try to run i
from the browser I get the following error:

Run-time error '1004':

Method 'Worksheets' of object '_Global' failed

The line causing this error is

curListHV_10 = Worksheets("Sheet3").Range("B2").Value

Can anyone tell me what to do so it works on my computer and when it'
downloaded from the Intranet.

Thanks,

Micki

--
Message posted from http://www.ExcelForum.com