user can't use workbook when already open

V

vqthomf

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
 
J

Jean-Yves

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Excel 2013 menubar incompatibility? 1
WORKBOOK OPEN 2
workbook directory where is it? 4
Code to select active workbook worksheet(s) in Excel 2007 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Call routines of other workbooks? 1
closing another file by code causes failure to run workbook activate event 2

Top