ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   user can't use workbook when already open (https://www.excelbanter.com/excel-programming/404691-user-cant-use-workbook-when-already-open.html)

vqthomf

user can't use workbook when already open
 
Hi I have a workbook with forms and code modules, the workbook has a password
on it to open and for the code window. The problem I have is that if the book
is open by a user another user can open it and with an error can't find code
module, when the user closes the book then then another user can then open it.
Has anybody had this problem before and is there anything I can do to fix it?.
Regards
Charles

Jean-Yves[_2_]

user can't use workbook when already open
 
Hi,

try to debug it and send theline of code that gives the erro.
Unprotect your project first.
Regards
JY

"vqthomf" wrote in message
...
Hi I have a workbook with forms and code modules, the workbook has a
password
on it to open and for the code window. The problem I have is that if the
book
is open by a user another user can open it and with an error can't find
code
module, when the user closes the book then then another user can then open
it.
Has anybody had this problem before and is there anything I can do to fix
it?.
Regards
Charles





All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com