Enable / Disable CommandBarControl

[DCSwearingen]

I am not sure what I did, but I disabled Worksheet Menu Bar > Tools > Macros

It is grayed out and even restarting Excel does not make it available again.

Can anyone tell me how to once again make it available?

All I know is I was working with creating VBA procedures before this happened...

[Leith Ross]

Hello DCSwearingen,

Place this macro in a a standard module and run it. It will re-enable your Macro selection on the menu.

Sub RestoreMacros()

  Dim CmdBar As Object
  Dim Ctrl As Object
  
    Set CmdBar = CommandBars("Worksheet Menu Bar")
    Set Ctrl = CmdBar.Controls("&Tools")
     
    Ctrl.Controls("&Macro").Enabled = True
    
End Sub

Sincerely,
Leith Ross

[DCSwearingen]

Thank You Very Much!!

I don't have any idea how I disabled that menu item.