ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display.Alerts problem when I unlock my computer (https://www.excelbanter.com/excel-programming/433662-display-alerts-problem-when-i-unlock-my-computer.html)

Andy

Display.Alerts problem when I unlock my computer
 
Hi,
My macro below is working great, however, when I lock my computer using
CTRL-ALT-Delete and then unlock my compter my VBA Editor pops up.

Any ideas on why my Editor pops up every time I unlock my computer?

Thank you,

Sub Display()
Application.DisplayAlerts = False
ChDir "C:\Macros"
Workbooks.Open Filename:="T:\Macros\Macros.xls"
ActiveWindow.Close
Range("J23").Select
Application.DisplayAlerts = True

End Sub


All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com