Are you using Office Visual Basic for Applications (VBA) macro project signing?
Please check in this article "Upgrade signed Office VBA macro projects to V3 signature (KB5000676)".
I would suggest you refer to the steps mentioned in this article to upgrade signature, then ues a new signature to have a look.
Hope the information could be helpful.
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.