code in VBAProject will not run

[Guest]

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

 

[Chip Pearson]

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 (e-mail address removed)

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.

 

[Bob Phillips]

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