Cannot Remove Trusted Document Prompt

Question

I've been working on a VBA-enabled spreadsheet, and (apparently), I made the mistake of using Evaluate() as an argument passed to a macro.

Ever since tagging that function as an argument to a macro assignment for a rectangle and reopening the workbook, I've been presented with a prompt stating (this won't let me upload images, my apologies):

BLOCKED CONTENT Trusted document settings have changed, not all content in this file is allowed to run. Review your Trust Center settings or contact your IT administrator.

The only piece of the workbook that had been disabled was this macro that I could find. That sucks in and of itself, because now I'm back to being stumped on how to determine what worksheet a call came from and passing the worksheet name as specified by a formula in a hidden cell sure was a nice clean solution for all of 5 minutes.

I cannot clear that warning now, and it is really beginning to aggravate me. I've tried temporarily allowing all macros in the Trust Center, ensuring that the folder the workbook is located in is trusted, moving the workbook to a local folder which isn't managed by OneDrive and trusting that; making copies of the workbook, removing all traces of the macro I apparently should be sorry I ever made, and I'm beginning to think that this warning may now be permanently tagged to the workbook no matter what steps I take.

I really hope not, I suppose I can copy the modules and worksheets over to a new book, but that seems absolutely ridiculous. I have other workbooks in the same directory with the same trust settings and they enable and allow VBA to run without issue. The workbook that is giving me this grief runs its macros absolutely fine otherwise as well, but this warning WILL NOT go away, and it's present on all of the worksheets.

Here's a crazy idea that is done by other Excel prompts that would be really cool to see implemented, you know, like LETTING ME KNOW WHAT FREAKING CONTENT IS CAUSING THIS PROMPT TO SHOW UP IN THE FIRST PLACE.

I'm hoping somebody else has dealt with this issue before and has a solution because I'm starting to pull my hair out on this one.

Thanks for your time!

Answer 1

I had this problem after adding a function =GET.CELL(17,[address]) and naming it "RowHeight". Deleting the name from the Name Manager solved the problem.

Answer 2

Hello Me -

Thanks for raising your concerns in Microsoft Community.

It sounds like you've already tried a lot of troubleshooting steps to resolve the issue. Here are a few additional suggestions you could try:

• Check for hidden or invisible macros: Sometimes, Excel can hide macros that are not visible in the macro list. To check for hidden macros, press Alt + F11 to open the Visual Basic Editor, then click on the VBAProject for the workbook in question, and look for any modules or sheets that have a visibility status of "Hidden". If you find any hidden macros, you can try deleting them and see if that resolves the issue.
• Check for named ranges or references: If your workbook has any named ranges or references that refer to external files, these can sometimes trigger the "Blocked Content" prompt. Try removing any named ranges or references that may be causing the issue.
• Clear the "Trusted Documents" list: If you've tried all the above suggestions and the issue still persists, you can try clearing the "Trusted Documents" list in Excel. To do this, go to the "Trust Center" settings, click on "Trusted Documents", and then click on the "Clear" button. This will remove all trusted documents from the list and force Excel to re-evaluate the security settings for your workbook.
• Disable Protected View: If you're opening the workbook from an untrusted location (such as a network share or the internet), Excel may automatically open the workbook in "Protected View". This can sometimes cause issues with macros and other content. Try disabling Protected View by going to the "Trust Center" settings, clicking on "Protected View", and unchecking all the boxes.
• Check for conflicting add-ins: If you have any Excel add-ins installed, they may be conflicting with your workbook and causing the issue. Try disabling any add-ins you have installed, and see if the issue goes away.

Hopefully one of these suggestions will help you resolve the issue. If not, could you please share this specific Marco excel file with my in your private message, it would be my pleasure to take a test,see here:

Best Regards,

Chandy |Microsoft Community Support Specialist