Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Long delay opening a workbook through our Intranet for some users | Links and Linking in Excel | |||
Dead screen on the intranet | Charts and Charting in Excel | |||
Publishing to intranet site | Excel Discussion (Misc queries) | |||
Unexpected (?) behaviour of OFFSET() in array formulas | Excel Discussion (Misc queries) | |||
Excel VBA forms on Intranet | Excel Programming |