lock a workbook... is it possible??

[sergio.exsa]

Hi, i want 2 know if i can disable a user to open a book in the activeworkbook where my book is open.... can anyone help?

Thanks..

 

[agihcam]

one option, paste this code in thisworkbook module;

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
ActiveWorkbook.Close
MsgBox "You cannot open another workbook while this workbook is open", vbCritical + vbOKOnly, "Restriction!"
End Sub