I've been working on a project for work that has been coming along quite nicely..... but today, I added a userform that simply displays a "Please wait...." box while some files are being processed after a GUI button is pressed.
I copied this userform code from another xls file and I know it is solid code. I exported it from the older xls file, then imported it to the newer xls file, as I have done so many times.
But this time around, while I can see everything in the VBA Editor Project Window and can open all the macros, including the ones imported with the userform, when I Compile it, I get an error that the 'Sub or Function isn't defined' and when I go to 'Tools/Macros' in the VBA Editor, the newly imported macros aren't listed.
It's as if these imported macros think they still belong to the old xls file. What do I need to do to make them a part of the new Project? I'm sure this will be a "Duh" moment when you answer me.
Thanks!
El
I copied this userform code from another xls file and I know it is solid code. I exported it from the older xls file, then imported it to the newer xls file, as I have done so many times.
But this time around, while I can see everything in the VBA Editor Project Window and can open all the macros, including the ones imported with the userform, when I Compile it, I get an error that the 'Sub or Function isn't defined' and when I go to 'Tools/Macros' in the VBA Editor, the newly imported macros aren't listed.
It's as if these imported macros think they still belong to the old xls file. What do I need to do to make them a part of the new Project? I'm sure this will be a "Duh" moment when you answer me.
Thanks!
El
