I need to have my workbook on our network to automatically save then close
from whichever workstation that it is opened at whenever a request to open
the workbook is made from a different workstation...
Computer #1 -- Viewing the workbook
Computer #2 -- Requests to open the same workbook
Computer #1 -- Workbook is saved and closed automatically with no override
Computer #2 -- Workbook is now opened