Display.Alerts problem when I unlock my computer

A

andy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top