I am trying to create a workbook for our traffic dept. to track all new orders. This workbook needs to stay open all the time so the traffic guy can see when a new order comes in.
I am fairly green to vba programming, so please be gentle...
The code below is what I currently have that works fine if the "traffic.xlsm" sheet is closed, but if it is opened, I get "Traffic.xlsm is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen Traffic.xlsm?"
I thought that by sharing the Traffic.xlsm spreadsheet, that this wouldn't be an issue, but it obviously isn't working as intended.
Can anyone tell me how we can keep Traffic.xlsm open all the time and still allow this code to execute from the main spreadsheet that populates Traffic.xlsm?
I thought if I just removed the last line, "ActiveWindow.Close", that it would work, but I'm obviously missing something more.