t0ny84
Board Regular
- Joined
- Jul 6, 2020
- Messages
- 205
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
Hi All,
Whilst helping another user with adding additional menus to their context menu (right click menu) in Excel I had added some additional menus to mine but thought I had cleared them all. When I just opened Excel I noticed on the Sheet Tab Context Menu the extra options still show. I was wondering if anyone knows how to reset this Sheet Tab Context Menu? I was able to reset all my other menus using the below code but they aren't working on the Sheet Tab Context Menu. I also found an add-in Menu Righter which removed it but when Excel was restarted they were back.
Thanks in advance,
t0ny84
Whilst helping another user with adding additional menus to their context menu (right click menu) in Excel I had added some additional menus to mine but thought I had cleared them all. When I just opened Excel I noticed on the Sheet Tab Context Menu the extra options still show. I was wondering if anyone knows how to reset this Sheet Tab Context Menu? I was able to reset all my other menus using the below code but they aren't working on the Sheet Tab Context Menu. I also found an add-in Menu Righter which removed it but when Excel was restarted they were back.
Code:
Application.CommandBars("Cell").Reset
Application.CommandBars("cell").Enabled = True
Application.CommandBars("Column").Reset
Application.CommandBars("column").Enabled = True
Application.CommandBars("Row").Reset
Application.CommandBars("row").Enabled = True
MenuRighter
MenuRighter – Excel 2010 and Later MenuRighter is an Excel addin that lets you modify right-click menus. You can add almost any control found in other right-click menus or Excel 2003’s …
yoursumbuddy.com
Thanks in advance,
t0ny84