Workbook_Open event not working

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

I have wrote a couple of routines in the Workbook_Open event
procedure, in workbooks that contain other routines in normal modules
aswell.
Everything works on my machine ok.
When a friend goes into these workbooks he can fire the procedures in
normal modules ok, but when he opens the workbook the Workbook_Open
procedure doesn't fire for him.

Any ideas??

J
 
I'll try this tomorrow Chip,
I'll place this line at the start of the workbook_open procedure &
I'll place it at the the end of the other normal modules in the
workbook
I'll report back as to whether this works

Cheers
J
 
Jason,

Putting the code in the Workbook_Open event won't do any good; if
EnableEvents is False, Workbook_Open won't execute. You need to do this
manually by typing the code in the Immediate Window.
 
Back
Top