I have multiple users using a database and certain positions run a macro that I built that runs two other macros. The first Macro works fine, but the second one on certain computers gives me action Halt error msg and none of the setting have changed anywhere.
To be very honest about it, converting all of your Macros to Code would be a great thing moving forward. You don't have to worry about misconnecting macros or moving them all properly. The code stays with the Forms/Reports or whatever you have wherever they go. Just something I learned that helped me out too. Now, I do everything in Code and eliminated all Macros. Not that Macros are bad, but Code is better and more flexible. And, not 100% sure but it was in the grapevine awhile back that Microsoft was thinking about dropping the Macros in some future versions of Office. Something to think about.