Workbook on intranet unexpected behaviour
 

Hi,

I gave a workbook to the intranet administrator who added a direct link to
my workbook
located on his server.
When opening the link, if you opening the file from its current location,
the workbook is loaded from within IE (version 6).

1. The open event load a form (fine), but it seems that not everything is
loaded properly.
The text box keypress event does not fire on first load of the form.

2. if you close the form and return to the workbook (still show in IE) and
then call the form
again via a start button :
This give an error - Set shData = Worksheets(2)
error message 'Method "worksheets" of object _ Global failed

I replaced by Worksheets(2)by Sheet2 but why is this object not known in
IE/excel ?

Regards,

Jean-Yves