Try adding a dummy argument to the other sub-routines - e.g. Private Sub UpdatePart(dummyArg as Integer)
That changes the "signature" of UpdatePart to be different from Main()
Make sub main() the last procedure of the module. That will ensure it starts from there when you run from the macro start button.
You can also add a customized macro button and specify the entry point.
1 person found this helpful
I am sure that the problem shall be fixed with Mike's suggestion above.
In case you still have issues. make all the other procedures and functions in your Macro module "Private" except sub Main(). This shall enforce VB to call Main only when you run the macro.
Hope it helps!!!