Tag not monitored by Microsoft.
Tag "office-excel-itpro" focuses on general issues about Excel clients.
Since your issue is more related to VBA code which is out of our scope of support and is not supported on Microsoft Q&A forum currently. I would modify the tag to be “not-supported”.
If needed, you may post your issue on the Excel for developers forum.
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.