I copy & paste some online VBA code into my excel 2007 to modify the right
click context menu as shown in the attached picture but now I don't know how
to change it back. I have tried the following VBA code but it doesn't work.
Please help.

Application.CommandBars("Cell").Reset

First off, I'm using a normal newsreader (as do most volunteers here), so
your picture attachment did not come through with your posting.

Second, instead of telling us what you did to try and correct the problem...
it would be better if you showed us the code that you say screwed things up
so we can see what took place to cause the problem.

--
Rick (MVP - Excel)


"cpmame" wrote in message
...
I copy & paste some online VBA code into my excel 2007 to modify the right
click context menu as shown in the attached picture but now I don't know
how
to change it back. I have tried the following VBA code but it doesn't
work.
Please help.

Application.CommandBars("Cell").Reset

Hi Rick,

I am sorry, but I really don't know which code causing that problem since I
cannot duplicate them. Can I send you a private message with the picture?
Please email me at , I will reply you back with the
picture. Please help.

Thanks
Jeff


"Rick Rothstein" wrote:

First off, I'm using a normal newsreader (as do most volunteers here), so
your picture attachment did not come through with your posting.

Second, instead of telling us what you did to try and correct the problem...
it would be better if you showed us the code that you say screwed things up
so we can see what took place to cause the problem.

--
Rick (MVP - Excel)


"cpmame" wrote in message
...
I copy & paste some online VBA code into my excel 2007 to modify the right
click context menu as shown in the attached picture but now I don't know
how
to change it back. I have tried the following VBA code but it doesn't
work.
Please help.

Application.CommandBars("Cell").Reset

I'm not Rick, but if you described the problem, you'd have more potential
responders.

But there are other rightclick context menus--"Ply" for the sheet tab, "Row" for
the row, "Column" for the column.



cpmame wrote:

Hi Rick,

I am sorry, but I really don't know which code causing that problem since I
cannot duplicate them. Can I send you a private message with the picture?
Please email me at , I will reply you back with the
picture. Please help.

Thanks
Jeff

"Rick Rothstein" wrote:

First off, I'm using a normal newsreader (as do most volunteers here), so
your picture attachment did not come through with your posting.

Second, instead of telling us what you did to try and correct the problem...
it would be better if you showed us the code that you say screwed things up
so we can see what took place to cause the problem.

--
Rick (MVP - Excel)


"cpmame" wrote in message
...
I copy & paste some online VBA code into my excel 2007 to modify the right
click context menu as shown in the attached picture but now I don't know
how
to change it back. I have tried the following VBA code but it doesn't
work.
Please help.

Application.CommandBars("Cell").Reset




--

Dave Peterson

Typically a right click on any cell will pop up a menu with Cut, Copy, Paste,
Paste Special, Insert, Delete... command. This time I am having another
standard floating toolbar menu sitting slightly above the default menu,
containing the command of Font, Font Size, Bold, Italic, Fill Color, Text
Color, Merge Cell and 11 more. It is now becoming a default menu so no matter
which excel file I open it is always there.






"Dave Peterson" wrote:

I'm not Rick, but if you described the problem, you'd have more potential
responders.

But there are other rightclick context menus--"Ply" for the sheet tab, "Row" for
the row, "Column" for the column.



cpmame wrote:

Hi Rick,

I am sorry, but I really don't know which code causing that problem since I
cannot duplicate them. Can I send you a private message with the picture?
Please email me at , I will reply you back with the
picture. Please help.

Thanks
Jeff

"Rick Rothstein" wrote:

First off, I'm using a normal newsreader (as do most volunteers here), so
your picture attachment did not come through with your posting.

Second, instead of telling us what you did to try and correct the problem...
it would be better if you showed us the code that you say screwed things up
so we can see what took place to cause the problem.

--
Rick (MVP - Excel)


"cpmame" wrote in message
...
I copy & paste some online VBA code into my excel 2007 to modify the right
click context menu as shown in the attached picture but now I don't know
how
to change it back. I have tried the following VBA code but it doesn't
work.
Please help.

Application.CommandBars("Cell").Reset




--

Dave Peterson

Are these options part of the "cell" commandbar that you see when you right
click on a cell -- or are they separate from it?

If it's part of the cell commandbar, I would have expected Rick's initial
response to fix the problem. So I'm going to guess that it's separate.

Does the popup menu look more like a floating toolbar (with a blue title bar) or
does it look more like the Cell popup?

If it has a header, then what's the caption you see on that header? Look for
the caption in the addins section of the excel options (under the Office button)
to see if you can turn it off.

My problem is that I don't use xl2007 enough to really help out.

But maybe you could report back and others will have enough info to help you....


cpmame wrote:

Typically a right click on any cell will pop up a menu with Cut, Copy, Paste,
Paste Special, Insert, Delete... command. This time I am having another
standard floating toolbar menu sitting slightly above the default menu,
containing the command of Font, Font Size, Bold, Italic, Fill Color, Text
Color, Merge Cell and 11 more. It is now becoming a default menu so no matter
which excel file I open it is always there.

"Dave Peterson" wrote:

I'm not Rick, but if you described the problem, you'd have more potential
responders.

But there are other rightclick context menus--"Ply" for the sheet tab, "Row" for
the row, "Column" for the column.



cpmame wrote:

Hi Rick,

I am sorry, but I really don't know which code causing that problem since I
cannot duplicate them. Can I send you a private message with the picture?
Please email me at , I will reply you back with the
picture. Please help.

Thanks
Jeff

"Rick Rothstein" wrote:

First off, I'm using a normal newsreader (as do most volunteers here), so
your picture attachment did not come through with your posting.

Second, instead of telling us what you did to try and correct the problem...
it would be better if you showed us the code that you say screwed things up
so we can see what took place to cause the problem.

--
Rick (MVP - Excel)


"cpmame" wrote in message
...
I copy & paste some online VBA code into my excel 2007 to modify the right
click context menu as shown in the attached picture but now I don't know
how
to change it back. I have tried the following VBA code but it doesn't
work.
Please help.

Application.CommandBars("Cell").Reset




--

Dave Peterson


--

Dave Peterson