Pop-up UserForm in an exclusive computer.

[Gilbfernandes]

Hi everyone, I have this Workbook with several UserForms. The Workbooks is shared between 2 or 3 Computers simultaneously. It is shared using the old way not the cloud.

One of the UserForms will work just like a Pop-up message in one especific computer. But, since it is just one workbook, I don’t want the Pop-up to show up in the other computers, just in that one specifically. The Pop-up is just a reminder for the person working in that computer that now he needs to do something in the workbook. This Pop-up is generated by one of the others Userforms on the others computers.

I can go get the IP for that specific computer if this is necessary to make somewhow the Pop-up to show up, but I don’t know how to make it work. IF there is any other idea not using the IP, I am open to anything. Any idea?

 

[Gilbfernandes]

I also thought about instead of opening a POP-UP UserForm, I could use The Workbooks.Open method and open another workbook on the specific computer, and this new workbook would contain only the UserForm Pop-up, but again I would need to identify the computer in some way.