Forum Discussion
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.