Solved: Re: Shared Workbooks

[TrippyTom]

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.

[Oorang]

Just the one that it is being run on.

[TrippyTom]

Thanks Oorgan, I was afraid of that.

There's rumor this shared workbook will soon be replaced by something we already are currently using (web-based) but it needs some kinks worked out to display the data we need better.