@Crock ,
We are mainly responsible for general issues of Office desktop applications, but your question is related to VBA, which is not supported on Q&A forum.
To better help you, it's recommended to post a new question on Office for Developers forum and Office developer community.
Thanks for your understanding.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.