View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck Buchanan Chuck Buchanan is offline
external usenet poster
 
Posts: 2
Default Sporadic problem with Enabling Macros

We're looking for a simple (but will accept a complicaed) answer to this problem ... thanks!

Occasionally (like once every 6-8 times), when enabling macros in a particular Excel workbook (loaded with VBA code and a UserForm), the ap gronks and forces a re-start. Then, when you re-open and re-enable the macros, either (a) everything is fine or (b) you get gronked again. Almost a 50-50 thing. Even more strange: what always seems to ensure a success is to open the file, disable the macros, save the file, open the file, and enable the macros

We're willing to share the workbook with anyone who wishes to see for themselves, and do appreciate your consideration of this matter. Email responses are welcome. Thanks.