Hi
In my Excel right click not working
What should i do
Thank you
Hi
In my Excel right click not working
What should i do
Thank you
Does the right click work in other software?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
yeah work in word and other program , but except in excel not work
Hi
No suggestion
Try the following in a new workbook and see if it works.
[VBA]
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]
Place in the This Workbook module and let us know the result
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Hi Aussiebear
I will try it , and reply you
Thank you
yes it's working
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
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.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Are you saying that the error still occurs in the existing workbooks?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.Originally Posted by thair younis
[VBA]Cbar.Enabled = "False"[/VBA]
And the commandbar would be:
[VBA]Application.CommandBars("Cell")[/VBA]
Look for these and let us know.
Regards,
--------------------------------------------------------------------------------------------------------
Shrivallabha
--------------------------------------------------------------------------------------------------------
Using Excel 2016 in Home / 2010 in Office
--------------------------------------------------------------------------------------------------------
Hi AussiebearOriginally Posted by Aussiebear
yeah the error still in my Excel
Originally Posted by 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.
Regards,
--------------------------------------------------------------------------------------------------------
Shrivallabha
--------------------------------------------------------------------------------------------------------
Using Excel 2016 in Home / 2010 in Office
--------------------------------------------------------------------------------------------------------
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
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.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Hi Aussiebear
Ok i will
thank you