1. I build a macro on an excel file worksheet and saved the file.
2. While using the file, I "save as" the file with other name.
3. When trying to edit and save the macro on the new file, the name on the tool bar was adding a reference that I dont understand:
Microsoft Visual Basic - FILE NAME - [MOLDULE4(CODE)]
I don't know why this "MODULE 4", but I imagine that it is causing a delay when I'm running the macro now...
Does anybody know how to save the macro on the new file, withou anylink to other sheets??
Tks!
In VB, right click the module and select Export, then in new file in VB, right click and select Import. This has to be done in VB, not the main Excel window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks