View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default 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