Right click

[thair younis]

Hi
In my Excel right click not working
What should i do
Thank you

[Aussiebear]

Does the right click work in other software?

[thair younis]

yeah work in word and other program , but except in excel not work

[thair younis]

Hi
No suggestion

[Aussiebear]

Try the following in a new workbook and see if it works.

Sub Enable_All_Right_Click_Menus() 
     'This will enable all BuiltIn Command bars
    Dim Cbar As CommandBar 
    For Each Cbar In Application.CommandBars 
        Cbar.Enabled = True 
    Next 
End Sub 

VBA tags courtesy of www.thecodenet.com

Place in the This Workbook module and let us know the result

[thair younis]

Hi Aussiebear
I will try it , and reply you
Thank you

[thair younis]

yes it's working

[thair younis]

but should I always use this code when i use excel
I want know what's the problem
and why I can't use right click without code

[Aussiebear]

Not sure. For some reason Excel's command bars are not being read correctly on loading, hence the loss of the right click function. I was hoping that someone with more experience could assist here.

[Aussiebear]

Are you saying that the error still occurs in the existing workbooks?

[shrivallabha]

Quote:   Originally Posted by: thair younis but should I always use this code when i use excel I want know what's the problem and why I can't use right click without code

It will happen when you have some other code which wants to "disable" right click for some reason. Check the codes that you run regularly, one of them will be having a code which will be opposite of what Aussiebear has provided.

Cbar.Enabled = "False" 

VBA tags courtesy of www.thecodenet.com

And the commandbar would be:

Application.CommandBars("Cell") 

VBA tags courtesy of www.thecodenet.com

Look for these and let us know.

[thair younis]

Quote:   Originally Posted by: Aussiebear Are you saying that the error still occurs in the existing workbooks?

Hi Aussiebear
yeah the error still in my Excel

[thair younis]

Quote:   Originally Posted by: shrivallabha It will happen when you have some other code which wants to "disable" right click for some reason. Check the codes that you run regularly, one of them will be having a code which will be opposite of what Aussiebear has provided. Cbar.Enabled = "False" VBA tags courtesy of www.thecodenet.com Hi shrivallabha This part from (Aussiebear) works well And the commandbar would be: Application.CommandBars("Cell") VBA tags courtesy of www.thecodenet.com But this line , when I put it in the code , give me error Look for these and let us know.

[shrivallabha]

Hi thair,

What I meant to say is:

1. Do you run some more macros other than the one posted by aussiebear above?
If yes, then search up those macros if they are disabling right-click completely.

2. What I have given is a sort of keyword for searching i.e. search criterion.

3. If you find such code then you will come to know about the reason why your right click doesn't work.

I hope this helps you.

[thair younis]

What I meant to say is:

1. Do you run some more macros other than the one posted by aussiebear above?
If yes, then search up those macros if they are disabling right-click completely.


Hi shrivallabha

I just run his aussiebear code not any other code

Thank you for replied me

[Aussiebear]

Have a look in the last couple of Excel files you were using before the right click function failed. As Shrivallabha has been quietly suggesting, there might well be some code in there that changes the right click function. This is something that you need to do as we do not have access to your files. If you find something or think you've found something, please feel free to post it.

[thair younis]

Hi Aussiebear
Ok i will
thank you