please fix the issue

Question

this error was showing

Answer 1

The workbook was saved as .xlsx

.xlsx files cannot store macros.

Save as Excel Macro-Enabled Workbook (*.xlsm).

Answer 2

Hi @r,

Thanks for reaching out.

This means the button is linked to a macro that Excel can no longer find, or macros are currently disabled for the file.

The first thing I’d recommend is reopening the workbook and checking if Excel shows an Enable Content prompt at the top. If it does, please click that first and then test the button again.

If the same message still comes up, right-click the button and select Assign Macro. From there, check whether the button is pointing to a macro named Sheet3_Button1_Click. If that name is listed but the macro is missing, the button will need to be reassigned to the correct macro, or that macro will need to be recreated in the workbook.

You can confirm this in the VBA editor by pressing Alt + F11. If the button was inserted as a regular Forms button, the macro should be stored in a standard module. If it was added as an ActiveX button, the click code should be inside the sheet where the button exists. Also make sure the workbook is saved as an .xlsm file, since Excel will not run embedded macros properly from a non-macro-enabled format.

If it still does not work after that, the next step would be to test the macro directly in the VBA editor and then create a new button in the workbook to rule out the current button being corrupted. If needed, moving the content into a new .xlsm workbook can also help confirm whether the issue is with the original file itself rather than the macro assignment.

Hope this helps! If my explanation and the information I provided were helpful, I would greatly appreciate it if you could follow the instructions here so others with the same problem can benefit as well.

Answer 3

please check your vba code. may be nothing inside the code block.

Answer 4

The error message indicates that Excel cannot find or execute the macro Sheet3_Button1_Click in Excel codeing.xlsm. This usually happens for one of these reasons:

1. The macro name does not match
   • Open the workbook.
   • Press Alt + F11 to open the VBA editor.
   • In the Project Explorer, expand VBAProject (Excel codeing.xlsm) → Microsoft Excel Objects → Sheet3.
   • Ensure there is a procedure named exactly:

          Private Sub Button1_Click()
          ' or
          Public Sub Button1_Click()
     

   • If the button is from the Form Controls toolbox, the macro it calls must be a standard Sub in a module (not a sheet) and the name in the Assign Macro dialog must match exactly.
2. The macro is in the wrong place
   • For an ActiveX button on Sheet3: the code must be in the Sheet3 code module, not in a standard module.
   • For a Forms button: the code must be in a standard module (Insert → Module), not in Sheet3.
3. Macros are disabled
   • Close the workbook.
   • Reopen it and, if a security bar appears, select Enable Content.
   • If there is no prompt, check macro settings: File → Options → Trust Center → Trust Center Settings → Macro Settings, and choose a setting that allows macros for trusted documents.
4. The button is assigned to a non‑existent macro
   • Right‑click the button in Excel.
   • Choose Assign Macro….
   • Select the correct macro from the list, or type the exact macro name that exists in VBA.
   • Click OK and test the button again.

After ensuring macros are enabled and the button is correctly assigned to an existing Sub with the exact same name, the error should no longer appear.

---

References:

• How to correct a #FIELD! error
• How to correct a #CONNECT! error
• Error containing URL "http://hubblecontent.osi.office.net/" when inserting an icon or a picture
• Can't attach photos to applications on Android Enterprise work profile enrolled devices
• Common errors creating and assigning Power Automate Approvals
• Add attachments to Microsoft Q&A
• Why is my profile image being investigated. "Your profile picture is under review" - Microsoft Q&A
• Error message when trying to download attachments from OWA 365 - Microsoft Q&A
• I select the Windows Spotlight but I only see this image in both my laptops! - Microsoft Q&A
• https://learn.microsoft.com/en-us/answers/questions/ask/?wt.mc_id=pcs_inproduct_azportal_caseask&portal=azure&context=sso&source=azure-portal Unable to access this even after accesses - Microsoft Q&A
• Unable to insert an image into my question on Q&A - Microsoft Q&A