Workbook_Open event not working
 

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

Workbook_Open event not working
 

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

"Chip Pearson" wrote in message ...
Jason,

It is possible that the EnableEvents property got set to False. Use the
following line of code to restore the property to True.

Application.EnableEvents = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"jason" wrote in message
om...
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

Workbook_Open event not working
 

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"jason" wrote in message
om...
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

"Chip Pearson" wrote in message
...
Jason,

It is possible that the EnableEvents property got set to False. Use the
following line of code to restore the property to True.

Application.EnableEvents = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"jason" wrote in message
om...
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