Why is my macro not working?

Question

Click the File tab, and then click Options at the very bottom of the left bar. On the left-side pane, select Trust Center, and then click Trust Center Settings… . In the Trust Center dialog box, click Macro Settings on the left, select Enable all macros and click OK. 11 мар. 2020 г.

What do I do if my macro is not working in Excel?

Enable macros just for the current session1Click the File tab.2In the Security Warning area, click Enable Content.3Select Advanced Options.4In the Microsoft Office Security Options dialog box, click Enable content for this session for each macro.5Click OK.Macros in Office files - Microsoft Support

How do I force macros to enable?

Steps to Force Users to Enable Macros in Order to View an Excel Workbook1Create a worksheet that you want users to see if they have not enabled macros. ... 2Make sure you have at least one other worksheet tab. ... 3Hit Alt + F11 on the keyboard to go to the macro editor.4Double-click where it says ThisWorkbook:Make Users Enable Macros in Order to View a Workbook in Excel

How do I fix a macro button?

The obvious solution is to make sure that the macro button is always attached to a cell that doesn't get deleted. Unprotect the workbook, select the sliver of the button near the column headers, and move it to a cell you want to associate it with. Reprotect the worksheet and the odd behavior should disappear.

Expert · Answer