View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 414
Default 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