GOSTARIA DE DESBLOQUEAR UM MACRO

Question

EU TENHO UM ARQUIVO QUE USAVA EM OUTRO COMPUTADOR, DAI QUANDO FUI BAIXAR NESSE, NAO CONSEGUI DESBLOQUEAR. NO OUTRO, FOI COMO AS INSTRUÇÕES.

JA TENTEI ENTRAR EM PROPRIEDADES, MAS NAO APARECEU PARA DESBLOQUEAR.

COMO NAO RECEBI POR EMAIL OU DE SITE, EU TINHA SALVO NO MEU WHATS, NAO SEI COMO FAZER PARA DESBLOQUEEAR

Answer 1

Dear Lisangela Nesello,

Thank you for reaching out. I understand you’re having trouble unlocking a macro-enabled file that worked on another computer. Based on your explanation, here are steps you can try to resolve the issue:

1. Check Trust Center Settings in Excel

• Open Excel and go to File > Options > Trust Center > Trust Center Settings.

• Under Macro Settings, select Enable all macros (not recommended, but useful for testing).

• Under Trusted Locations, add the folder where your file is saved to ensure it is recognized as secure.

2. Unblock the File in Properties

• Right-click the file, select Properties, and look for an Unblock checkbox under the General tab.

• If the option isn’t available, the file may not be flagged as downloaded from an untrusted source.

3. Move the File to a Trusted Folder

• Save the file to a local folder, such as Documents, and try opening it again. Files stored in messaging apps or temporary locations may not be fully trusted.

4. Re-enable Content

• When opening the file, look for a yellow Security Warning banner at the top of Excel. Click Enable Content to activate the macros.

5. Check File Format

• Ensure the file is saved as a macro-enabled file (.xlsm). If not, save it in the correct format and reopen it.

If these steps don’t resolve the issue, feel free to provide more details about the error you’re encountering, and I’d be happy to assist further.

I hope this helps! Please forgive me if my understanding of your situation isn’t perfect, as this was based on translation. Let me know if anything needs clarification.

Best regards,

Yuki