How to solve " The macro may not be available in this workbook ...." Help

Sharif Taha

New member
Joined
Dec 18, 2015
Messages
9
Reaction score
0
Points
0
Dear all
I tried to open this file but always i got
" The macro may not be available in this workbook or all macros may be disabled"
although I Did the following :

  1. Click the Microsoft Office Button, and then click Excel Options.
  2. Click Trust Center.
  3. Click Trust Center Settings.
  4. Click Macro Settings.
  5. Click to select the Trust access to the VBA project object model check box.
  6. Click OK to close the Excel Options dialog box.

but nothing works

how to solve this problem

I have windows 10 and office 2016
the file is in arabic language
and i tried to make windows and office in arabic but this also doe not work

help



 
I'm not sure, i think you must go to macros and delete the current macro because for some reason the name of macro doesnt match with the Sub MyMacro() inside the VBA Code. Check it. If this is the problem, renew your button with macro.
Long ago this worked for me.
 
Back
Top