ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom right-click menu without changing Excel.App (https://www.excelbanter.com/excel-programming/434838-custom-right-click-menu-without-changing-excel-app.html)

TBD

Custom right-click menu without changing Excel.App
 
Greetings,
Is it possible to have a custom (3 items) pop-up menu when the user
right-clicks on a cell, but without any chance of permanently deleting the
default application menu options?

Q. Can I just disable the default right-click menu and get Excel to use a
different "custom" menu on right-click? (am web-searching this now...)

If not, and I must directly default right-click options via:
..CommandBars("Cell").Controls().Delete,
Q. Is it possible to guarantee these deletions are temporary? (as with:
CommandBars("Cell").Controls.Add(Temporary:=True) )

Thanks/Cheers!
--
The Cobra
[Footnote:] A few Cobras in your home will soon clear it of Rats and Mice.
Of course, you will still have the Cobras. (a quote by Will Cuppy
http://en.wikiquote.org/wiki/Will_Cuppy)

TBD

Custom... GOT IT!
 
Sometimes it takes a while to sort the lumps from the goo.

http://www.mrexcel.com/forum/showthread.php?t=84464

Cheers!
--
The Cobra
[Footnote:] A few Cobras in your home will soon clear it of Rats and Mice.
Of course, you will still have the Cobras. (a quote by Will Cuppy
http://en.wikiquote.org/wiki/Will_Cuppy)


"tbd" wrote:

Greetings,
Is it possible to have a custom (3 items) pop-up menu when the user
right-clicks on a cell, but without any chance of permanently deleting the
default application menu options?

Q. Can I just disable the default right-click menu and get Excel to use a
different "custom" menu on right-click? (am web-searching this now...)

If not, and I must directly default right-click options via:
.CommandBars("Cell").Controls().Delete,
Q. Is it possible to guarantee these deletions are temporary? (as with:
CommandBars("Cell").Controls.Add(Temporary:=True) )

Thanks/Cheers!
--
The Cobra
[Footnote:] A few Cobras in your home will soon clear it of Rats and Mice.
Of course, you will still have the Cobras. (a quote by Will Cuppy
http://en.wikiquote.org/wiki/Will_Cuppy)



All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com