Having trouble enabling my macros

%3CLINGO-SUB%20id%3D%22lingo-sub-2751192%22%20slang%3D%22en-US%22%3EHaving%20trouble%20enabling%20my%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2751192%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20friends%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20some%20assistance%20with%20my%20excel%20worksheet.%20I%20have%20enabled%20my%20macros%20but%20it%20still%20is%20saying%20I%20have%20block%20content%20and%20can't%20edit%20my%20excel%20worksheet.%20If%20anyone%20can%20help%20I%20would%20greatly%20appreciate%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2751192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2752218%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20trouble%20enabling%20my%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752218%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1156106%22%20target%3D%22_blank%22%3E%40Natasha2210%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ef%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%26nbsp%3B%3C%2FP%3E%3CP%3EAsk%20away.%3C%2FP%3E%3CP%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CSPAN%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eclick%20on%20the%20Link%20for%20informations.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello friends,

 

I need some assistance with my excel worksheet. I have enabled my macros but it still is saying I have block content and can't edit my excel worksheet. If anyone can help I would greatly appreciate it. 

 

Thank you  

2 Replies

@Natasha2210 

 

f you’re looking to ask a question or start a conversation about Excel, you’re in the right place! 

Ask away.

Please include the following info to help others answer your question:

Welcome to your Excel discussion space!

click on the Link for informations.

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

@Natasha2210 

First of all (Macro does NOT work on Excel Online spreadsheets)

 

Regarding Excel desktop, that can be your situation: 

I would suggest you before you open any of your excel file, you set up your macro setting under 

File > Options >Trust Center > Trust Center Settings > Macro Settings

After you set up your excel, you can open the file that contains the macro.

JulianoPetrukio_0-1631702734760.png