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