Can I use Excel macros when I have Jet Professional active within Excel?
While we have found that it is certainly possible to have and use macros within Excel while Jet Professional is active, we have no control over what those macros do. It is possible for macros to interfere with the functionality of Jet Professional.
For this reason, (as noted on our Help Center ...) "Jet Reports does not support macro enabled reports. If a macro enabled report needs troubleshooting, all macros must be disabled by the client before requesting assistance."