Hi,
When i right click to my mouse,the Insert option is deactivated.
Screenshot is attached herewith.
Please guide me how to activate it.
Thank You
Kapil
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Insert option in mouse deactivated
0
Answers
0
Selected Answer
Go to registry editor
1. run command regedit
2. Locate "Office\15.0\Excel\Options" (number 15 may vary with the version you have)
3. Delete Options tab
4. Restart excel
This advice was given by Rajkul Fulzele, Rationalist. The whole thread where he published it can be followed here.
Discussion
Hi,
Above mentioned option did not work for me.
But i explored other threads in same website where i found below thread and it worked for me.
Go to "C:\Users\<User profile>\AppData\Roaming\Microsoft\Excel"
and rename Excelxx.xlb file name.
Eg: Excel14.xlb or Excel15.xlb
Thank You
Above mentioned option did not work for me.
But i explored other threads in same website where i found below thread and it worked for me.
Go to "C:\Users\<User profile>\AppData\Roaming\Microsoft\Excel"
and rename Excelxx.xlb file name.
Eg: Excel14.xlb or Excel15.xlb
Thank You
KDRAGHU (rep: 16) May 12, '20 at 11:38 am