M
Mechi1
I don't know if I'm at the right place because there is 3 MS products
involved Excel, IE and IIS. But throwing a Q here is a start.
The problem is that an Excel workbook we're working on, heavily dependent on
vba and events like onopen, onclose, onselection_change, etc., won't run ANY
user triggered events if the file is locked for editing by another user and
file is opened by a link on a local intranet site with IE... I'll take it
again
The workbook use macros and events to do several things like auto save and
close, and the code has a fail safe to avoid people from turning off macros
in Excel when opening it. The workbook is totally locked down if macros can't
run (unless you have the password ofc).
This workbook is then put on our intranet for everyone to use and edit,
though we only allow one user at a time. This is why we created an auto save
and close so people wont forget to close the wb and lock other users out.
Normally this works out quite well until the occasion when a user wants to
access the wb when it's already opened by another user. IF the user tries to
open the locked file through IE using the webpage provided hyperlink, no vba
events get triggered what so ever. Workbook_Open, Workbook_BeforeClose,
Workbook_BeforeSave, etc. But other macros can be executed so macros haven't
been deactivated. On the other hand if the user instead browses the file on
the server and opens it with Windows Explorer or in any other way, everything
works fine and events are fired like normal.
What are we doing wrong? Bug or settings?
Using: IE 6 and 7, Excel (Office) 2000, 2002 and 2007, IIS v?, XP pro...
involved Excel, IE and IIS. But throwing a Q here is a start.
The problem is that an Excel workbook we're working on, heavily dependent on
vba and events like onopen, onclose, onselection_change, etc., won't run ANY
user triggered events if the file is locked for editing by another user and
file is opened by a link on a local intranet site with IE... I'll take it
again
The workbook use macros and events to do several things like auto save and
close, and the code has a fail safe to avoid people from turning off macros
in Excel when opening it. The workbook is totally locked down if macros can't
run (unless you have the password ofc).
This workbook is then put on our intranet for everyone to use and edit,
though we only allow one user at a time. This is why we created an auto save
and close so people wont forget to close the wb and lock other users out.
Normally this works out quite well until the occasion when a user wants to
access the wb when it's already opened by another user. IF the user tries to
open the locked file through IE using the webpage provided hyperlink, no vba
events get triggered what so ever. Workbook_Open, Workbook_BeforeClose,
Workbook_BeforeSave, etc. But other macros can be executed so macros haven't
been deactivated. On the other hand if the user instead browses the file on
the server and opens it with Windows Explorer or in any other way, everything
works fine and events are fired like normal.
What are we doing wrong? Bug or settings?
Using: IE 6 and 7, Excel (Office) 2000, 2002 and 2007, IIS v?, XP pro...