I'm having issues calling procedures that I created in modules from other procedures.
For example, I have an ActiveX button in my worksheet with the following in the code to that specific worksheet:
Sub ExampleButton_Click()
Call ExampleSub
End Sub
And in a module, I've written:
Sub ExampleSub()
...
End Sub
When I run the first sub, I get the following error:
Compile error:
Expected variable or procedure, not module
I'm wondering if it has something to do with my macro settings (although I'm sure they're currently enabled), because I also have a splash screen (user form with info on it that runs when the application opens) that is set to kill at a certain time by running another procedure that unloads the userform. This procedure (KillForm) is saved in a module, as well, and called from another procedure. It is also not working.
Thanks!
Bookmarks