TrippyTom
07-01-2008, 04:03 PM
I've recently been asked to update a shared workbook my department uses (30 people on 3 different shifts - not all the same time).
My question is, if I write code to simply pop up a msgbox, will that be shown on ALL computers who happen to be logged into the file? Or will it just show up on the current PC that activates the macro?
I want to remind people to get out of the file so I can update it, so I was hoping a msgbox would be the simple solution.
My question is, if I write code to simply pop up a msgbox, will that be shown on ALL computers who happen to be logged into the file? Or will it just show up on the current PC that activates the macro?
I want to remind people to get out of the file so I can update it, so I was hoping a msgbox would be the simple solution.