I have VBA Code that opens a workbook and when it does the MS Dialog box appears (as it should) that shows it as opening. However, the dialog box will just sit there until I hit the x close button or cancel and then the code continues on. No Errors, no skip error statements in the code either. But get this, It still opens the workbook up does it thang. Then when it Saves the workbook, it hangs on the MS dialog box for saving until I close it out. It saves the workbook though. What in the world would cause this. It was not doing this last week. I am using the latest Excel 365 ProPlus Desktop Version with the latest Updates. It works but other users do not know what to do or what is going on with it. I also tried adding Application.EnableEvents and set to false thinking it would ignore the dialog box but it doesn't.
