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

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

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

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