Right Click Disabled on Buttons with Assigned Macros

[VanceLiving]

Hello,

I use Excel 2010 and about a week ago, for whatever reason, my right-click ability was disabled in Excel only. I have replaced certain functionality on individual basis with code (see below) that has re-enabled my ability to right-click on rows, columns, and sheets.
Public Sub reset()
Application.CommandBars("Cell").Enabled = True
Application.CommandBars("Row").reset
Application.CommandBars("Row").Enabled = True
Application.CommandBars("Column").reset
Application.CommandBars("Column").Enabled = True
Application.CommandBars("Ply").Enabled = True
End Sub

However, I am also unable to right-click on buttons which have assigned macros and I cannot find the solution. I thought the code below would do the trick but no luck. Any idea what might work? Thanks in advance for your help!!

Application.CommandBars("Button").reset
Application.CommandBars("Button").Enabled = True

-Vance

 

[Andrew Poulsom]

If your CommandButtons are from the Control Toolbox you need to be in Design mode to right click them. For Form controls the CommandBar is "Excel Control".

 

[VanceLiving]

Andrew,

That did it - thank you very much!!