Excel is Blocking Excel Macros

Hi RC

I'm Anna and I'd be happy to help you with your question. In this Forum, we are Microsoft consumers just like yourself.

Sorry for the trouble this might have caused. Are the files from the internet, such as an email attachment, that file contains macros? If yes, then you might need to see the article below

https://learn.microsoft.com/deployoffice/security/internet-macros-blocked

If not, you can tell us:

* What version of Office do you have? * Your Operating system?

Also, please see if you can open this file using Excel for the web www.office.com

I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

Best Regards,

Anna

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

RE: selfcert.exe

My applications seem not to have this file readily available. I did find a version of it that seemed to be implemented for 32bit applications, but it did not execute on my machine. I have not looked for it elsewhere.

I used selfcert.exe successfully on excel2003 32bit many years ago.

Sorry, I am not clear sbout 64bit office.

But 32bit selfcert.exe should be Ok on 64bit windows.

https://blog.csdn.net/qq\_17771109/article/details/111934040

https://support.microsoft.com/zh-cn/office/%E8%8E%B7%E5%8F%96%E6%95%B0%E5%AD%97%E8%AF%81%E4%B9%A6%E5%B9%B6%E5%88%9B%E5%BB%BA%E6%95%B0%E5%AD%97%E7%AD%BE%E5%90%8D-e3d9d813-3305-4164-a820-2e063d86e512?redirectsourcepath=%252fen-us%252farticle%252fobtain-a-digital-certificate-to-create-a-digital-signature-998114c0-dd81-433a-815b-47dcb90f5a6d#ID0EBBF=Newer\_versions

Or create it by youself

https://blog.csdn.net/weixin\_34062469/article/details/91857815

Thank you Anne and peiyezhu for your responses yesterday.

This particular issue seems to have disappeared overnight. The troublesome files with macros no longer trigger a "blocked" message.

Either the changes/additions I made in the Trust Center eventually, after a delay, began to work or something Microsoft did over the last 24 hours removed the problem.

RE: selfcert.exe

My applications seem not to have this file readily available. I did find a version of it that seemed to be implemented for 32bit applications, but it did not execute on my machine. I have not looked for it elsewhere.

You can create your own digital certificate for personal use or testing purposes with the SelfCert.exe tool that is provided in Microsoft Office.

https://learn.microsoft.com/en-us/office/troubleshoot/excel/digital-signatures-code-signing

sign your Visual Basic for Applications macro project, follow these steps:

Open the workbook that contains the macro project that you want to sign.

Press ALT+F11 to open the Visual Basic Editor.

In the Project Explorer, select the project that you want to sign.

On the Tools menu, click Digital Signature.

Do one of the following:

If you have not previously selected a digital certificate, or if you want to use another one, click Choose, select the certificate, and then click OK two times.

To use the current certificate, click OK.

https://answers.microsoft.com/en-us/msoffice/forum/all/share-excel-web-workbook-and-force-copy-in-order/46a01490-bded-4117-8213-8879e504f49c

Hi Anna

Thanks for responding so quickly.

So, No, the file problem files did not come from the internet. They are small personal VBA macros to simply certain cell-based operations want to perform. So the macros are "Private Function" type. So, they are "user functions".

That said, these files reside on my personal OneDrive space. At least one message I have received today suggests that the app is interpreting OneDrive as having an internet source.

Your other questions:

Office Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2210 Build 16.0.15726.20068) 32-bit 

OS: Windows 10 Pro, Build 19044.2130

I have found a small workaround. I save my VBA macros in a little temp file with the source code in a module. I save the file that used to be an xlsm file as an xlsx. I open the xlsx, then copy the module from the temp file to the working file. Fortunately, the user functions called from the workbook execute successfully. But I don't want to have to do this every time I open the file.

RC