Reset Right Click Menu

[Ronbo]

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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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("yourcontrolname").delete or reset
your commandbars.

So long.


"Ronbo" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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]

Ronbo

To remove.......

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


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 12:45:04 -0800, "Ronbo" <[email protected]>
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