I'm getting strange behavior when trying to use Event Procedures In VBA. Here's the setup.
I have a .xls file that has an add-in .xla file. I store all the code in the .xla file, since the code has a digital signature (to avoid the macros message), and the .xls file is a shared workbook which will be saved by users without access to the digital signature private key.
On the .xla file, on the ThisWorkbook object, I include code to access the events of objects on the .xls file.
This seems to work fine...unless I code something in error. This seems to "break" the code, and completely disable any of the functionality tied to the event procedures for Workbook and Worksheet. I have to rollback my code (comment out the event procedures) for WBk and WBs. If I enable the Workbook object, it still will not function unless I rename it, like so:Please Login or Register to view this content.
This seems a very illogical behavior to code to, so am I missing something in how to code event procedures, or is there some insight anyone has on this?Please Login or Register to view this content.
Now I've got the Workbook object recognized if I have the Worksheet declaration commented out, but no matter how I tinker with the Worksheet object and change the name, whenever I uncomment the declaration, none of the code in the .xla runs when the .xls is opened.
Thanks for any help!
Bookmarks