PDA

View Full Version : Excel 2003 - Can I notify user that I'm waiting for read/right access to a workbook?



frank_m
01-22-2011, 04:54 PM
If I go to open a workbook that is already open on the network by another user, and I then click notify, is it possible to somehow notify that user that I'm waiting for read/right access?

Thanks

Kenneth Hobs
01-22-2011, 06:24 PM
Use one of these or a combination.
1. MsgBox()
2. Userform
3. Application.Statusbar

frank_m
01-22-2011, 09:17 PM
Thanks Kenneth, are you suggesting an Excel userform or msgbox?
-- how would I be able to initiate either of those from my computer,, to pop up on the other users computer?

Kenneth Hobs
01-22-2011, 09:21 PM
You would have to have network rights to send messages to do that sort of thing. The exact method depends on the network. Of course you could send an email.