ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reset Right Click Menu (https://www.excelbanter.com/excel-programming/320655-reset-right-click-menu.html)

Ronbo

Reset Right Click Menu
 
I added a command to the "right click menu" and want it remoced. How do I
remove it or restore the "right click menu" to its default state?

Thanks

Bob Phillips[_6_]

Reset Right Click Menu
 
Type this into the VBE immediate window

application.CommandBars("Cell").Reset

and enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ronbo" wrote in message
...
I added a command to the "right click menu" and want it remoced. How do I
remove it or restore the "right click menu" to its default state?

Thanks




anonymousA

Reset Right Click Menu
 
Hi

I guess you added a control in the Application.commandbars("cell").
So to remove what you added, just write down
Application.commandbars("cell").controls("yourcont rolname").delete or reset
your commandbars.

So long.


"Ronbo" a écrit dans le message de news:
...
I added a command to the "right click menu" and want it remoced. How do I
remove it or restore the "right click menu" to its default state?

Thanks




Gord Dibben

Reset Right Click Menu
 
Ronbo

To remove.......

Application.CommandBars("Cell").Controls("Your Item").Delete


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 12:45:04 -0800, "Ronbo"
wrote:

I added a command to the "right click menu" and want it remoced. How do I
remove it or restore the "right click menu" to its default state?

Thanks




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

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