We have a shared workbook which is password protected. When a user opens the file, the password message box pops up asking for a password or read only. The problem is, if somebody leaves that message box up on their computer, it locks the file for everybody. (it took me a couple years to figure out that is what causes the "File is Locked" message) Is there anyway to put a timer on that message box?
If not, is there a way to get a user form to ask for a password? I would create a form in another workbook with links to this one.
Thanks,
If not, is there a way to get a user form to ask for a password? I would create a form in another workbook with links to this one.
Thanks,