So, I run a fantasy baseball website that distributes a macro-enabled Excel spreadsheet as one of the main parts of the site. There's a lot of VBA coding, macros, forms and such that are part of the spreadsheet in order to make it interactive and responsive. Anywho, I released the cheatsheets today and I'm being littered with people saying they're getting the run-time 32809 error when they try to open the workbook. While I've directed some people to the Microsoft site that has the Fix-It solution, this seems silly for me to expect everyone to do (and, still, others have done it and still said it's not working).
So, from my research, this error is related specifically to ActiveX problems, right? I could go through and modify the whole workbook to remove anything ActiveX related but I'm curious if anyone knows what that all entails. I know there would be command buttons but what about UserForms? Are those ActiveX? I guess what should I be looking for if I'm going to try to make my spreadsheet proofed to avoid this error.
Thanks.
Bookmarks