code in VBAProject will not run
 

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

code in VBAProject will not run
 

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

code in VBAProject will not run
 

.... 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