I have a workbook That is open at the beginning of the day shift and stays open all day by a user inputting data every 5-10 minutes. I wanted to open this workbook and keep it open all day to seeing data update as is entered. Sorvek came with a very cleaver solution;
Now I need to when clicking the refresh button get rid off these message boxes (pictures inside workbook sheet1) Can the code be complemented to when clicking the button the workbook just opens?
Right now I'm at home using my VPN and I put the workbook in a network drive, opened it, clicked another instance of Excel and opened the same workbook (read only) and came to the first original and modified a bit clicked save and when I go back to the read only and click the Refresh button IT WORKS!
I know this is as easy as just open and close the workbook and it will be updated, but think about convenience to user, every sheet has a time stamped in the top left corner, so my user can see the last time was open and if is 10-20 minutes old just click a button and there you have it a refreshed workbook!
This has been one of the Access junkies you Excel people "can do this" things that been driving me nuts, I think Kevin has hit the nail right on the head.
Can some body tell me how can I complement this code to get rid off these message boxes?
Can this be done, specially the "This workbook is lock for editing" msgbox, and why is that the other msgbox comes up when running the code?
Thanks in advance for any input.