Security

[SAM]

I have an excel worksheet with a password on my network drive.Is there a way if someone try to use the same file (while I am using the worksheet), to get a message something like "the file is in use" instead of showing a password to open box.
Thanks for any help

 

[Juan Pablo González]

Mhmm, only way I can imagine is to use a "master workbook" to open the other workbook, and then, if it's read only, the workbook should be open, then you could display the message... but, it's not the "best" way i feel...