I've done this with my own code and several examples, online. I set up a class module with events at the application level. I have, for example, a worksheet activate event.
Everything works fine, HOWEVER, if at the spreadsheet, I hit the DESIGN icon to go into design mode (e.g., to add active-X controls, or whatever) and then exit out of design mode, the application level events don't work, unless I reinitialize them.
Is this supposed to happen? What could be the cause of it happening, if not? I can pick any of a number of examples online and make this happen - even the simple example from Chip Pearson's website.
Any thoughts? This is really cramping my style, lol!