Hi All,
I have a excel workbook that will not run any of the vba events. After creating a new workbook and coping the sheet data the events will run, but, after closing and reopening the workbook the events stop runing.

any help is appreciated,

mike

Mike,

Search the code for Application.EnableEvents = False and ensure that there
is a corresponding Application.EnableEvents = True .


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

"Mike" wrote in message
...
Hi All,
I have a excel workbook that will not run any of the vba events. After
creating a new workbook and coping the sheet data the events will run, but,
after closing and reopening the workbook the events stop runing.

any help is appreciated,

mike

.... and that any error handling in that area re-enables events.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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

Search the code for Application.EnableEvents = False and ensure that there
is a corresponding Application.EnableEvents = True .


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

"Mike" wrote in message
...
Hi All,
I have a excel workbook that will not run any of the vba events. After
creating a new workbook and coping the sheet data the events will run,
but,
after closing and reopening the workbook the events stop runing.

any help is appreciated,

mike