Right-click pop-up menu disabled

[dellamic]

I have written a VBA procedure in Excel 2010 that tries to hidden commandbars and prevents several actions from the user.
I have included and run this code:

Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = False
Next

Now, when I opn ANY excel file the righ-click gives no action. I have to run a procedure with the same lines, but
Cbar.Enabled = True
to have the pop-up menu available with the right mouse button. The right-click works correctly in all other Office programs (word, etc)

Someone can help me ?

Thanks

Mauro

 

[Firefly2012]

Assuming you don't have that disable code running every time you start Excel then possibly you have a corrupt xlb file (this stores your user customisations such as menu bars). With Excel closed, search for a file of filename .xlb on your harddrive and once found change its extension to xlbOLD and restart Excel. Hopefully you will still have your right-click menu then.

 

[dellamic]

Assuming you don't have that disable code running every time you start Excel then possibly you have a corrupt xlb file (this stores your user customisations such as menu bars). With Excel closed, search for a file of filename .xlb on your harddrive and once found change its extension to xlbOLD and restart Excel. Hopefully you will still have your right-click menu then.

GREAT: It solves the problem !

Many thanks