@vincehardwick We did code sign our VBA product, distributed it to thousands of users, out of which almost all recently added a worksheet or deleted a worksheet manually and the signature was lost. With the new update, they couldn't use the file anymore. Months and years of hard work gone in seconds.
It doesn't make sense to lose the signed VBA certificate if a user adds a sheet but its a shame and that's just how it is (Only if the user makes a code change to a signed copy then the signature/ signed cert should be discarded - Not sure why Microsoft won't fix this).
If Microsoft fixes all the bugs around 'not discarding VBA signature' when users make worksheet changes then this solution may work in the future but until then it should let us macros users enjoy the brilliant software it has given us.