code in VBAProject will not run

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Mike said:
Hi All,
I have a excel workbook that will not run any of the vba events. After
Click to expand...
creating a new workbook and coping the sheet data the events will run, but,
after closing and reopening the workbook the events stop runing.
 
.... 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)
 
Back
Top