Forum Discussion
Password to modify pop-up after VBA timeout
Hi! I have a spreadsheet that uses the Password to modify option from the Save As>Tool>General Options menu to allow the general production folk to access the file in Read-Only and the Engineering t...
How about trying to temporarily switch to another workbook for another workbook take focus right before the close:
Sub CloseDownFile()
Application.ScreenUpdating = False
Workbooks.Add 'Creates a temporary new workbook
Workbooks("WorkbookName.xlsm").Close SaveChanges:=False
Application.ScreenUpdating = True
End Sub