Forum Discussion

ghorivipul42's avatar
ghorivipul42
Tin Contributor
Oct 27, 2026

macro not avaliable in this workbook

macro may not be available in this workbook. 

All ready try to trust centre, trust centre option 

 

 

1 Reply

  • Your screenshot identifies AddEditEmployerIncome in the WBC calculator workbook, but Excel’s message combines two possibilities: the procedure cannot be found, or macro execution is blocked. Changing Trust Center alone cannot repair a missing or incorrectly assigned procedure.

     

    Make a backup, then open Developer > Macros and set “Macros in” to the current workbook. Check whether AddEditEmployerIncome is listed. If it is, compare the button’s assigned macro with that procedure and the workbook you actually opened; a button can still reference another copy. For a Form control, right-click it and choose Assign Macro.

     

    If the procedure is absent, request a fresh, complete macro-enabled workbook from the calculator’s publisher rather than inventing replacement code. If Excel displays a Security Risk banner, have your administrator or publisher review the file’s trust and applicable policy. Avoid enabling all macros globally. The exact error and assignment comparison will distinguish the next step.