how to unblock macros

Question

i have difficulties in unblocking macros when using excel

Answer 1

Hi,

#1:

Please select the file > Press ALT+Enter to open Properties.

Click the General tab > Unblock the file.

#2: Safer option:

1. Open Excel and click on File, then select Options at the bottom left.
2. Click on Trust Center in the left-hand menu.
3. Click the Trust Center Settings button.
4. Select Trusted Locations from the left panel.
5. Click Add new location at the bottom.
6. Click Browse to find and select the folder where you want to save your safe macro files.
7. Click OK on all the open dialog boxes to save your changes.

I hope this information helps. If you have any more questions, don't hesitate to reach out.

Otherwise, if your problem is resolved, please take a moment to rate the answer. Wishing you good luck!

Answer 2

Hi @MOHAMED SHANO

1.

Right‑click the Excel file

Choose Properties

At the bottom, check if you see:

“This file came from another computer and might be blocked”

Click Unblock

Click Apply → OK

Reopen Excel

2.

Open Excel → File → Options → Trust Center → Trust Center Settings → Macro Settings

Choose:

Enable VBA macros

Trust access to the VBA project object model

Thanks.