View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Jack Sheet Jack Sheet is offline
external usenet poster
 
Posts: 47
Default Workbook_Open() will not run

It returns True.

No sweat I shall reconstruct. It would be nice if there were a one-click
utility out there to do that.


"Harald Staff" wrote in message
...
Ok, sorry, didn't see that one. Does ANY workbook event run at the time?

Try
this code for Auto_open:

Sub Auto_open()
MsgBox Application.EnableEvents
End Sub

if it returns False then something has disabled workbook and worksheet
events. Auto_Open is not part of the events, so that runs fine.