Screwed Up my Right Click Context Menu, Please Help

[cpmame]

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

 

[Rick Rothstein]

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.

 

[cpmame]

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 (e-mail address removed), I will reply you back with the
picture. Please help.

Thanks
Jeff

 

[Dave Peterson]

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]

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]

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....

 

[Dave Peterson]

Ignore that previous message.

xl2007 won't allow you to have those floating toolbars.

So...

Does this happen in all workbooks or just a single workbook or even a single
worksheet?

If you start excel in safe mode (I think xl2007 allows this), does the problem
go away?

Close excel
Windows start button|Run
excel /safe

And test it out.

Maybe it's a "helpful" macro that's intercepting the rightclick and showing what
it wants to--along with the standard cell popup.

 

[Dave Peterson]

And I see by a later post that you were the culprit. You were trying to
intercept the rightclick event!

 

[cpmame]

Hi Dave,

I have just learned that it is called the "mini toolbar", and looks exactly
like this
http://office.microsoft.com/en-gb/excel/HA101736241033.aspx

I had tried to uncheck that option according to the suggestion above, and
even reboot my computer but it still doesn't go away.

I have posted another thread here and I think you can see the picture there
http://www.excelforum.com/excel-gen...ick-context-menu-please-help.html#post2057001

And I see by a later post that you were the culprit. You were trying to
intercept the rightclick event!

 

[Dave Peterson]

Try this in your code:

Application.ShowMenuFloaties = True

Ron de Bruin as passed it on to MS as a bug.

Hi Dave,

I have just learned that it is called the "mini toolbar", and looks exactly
like this
http://office.microsoft.com/en-gb/excel/HA101736241033.aspx

I had tried to uncheck that option according to the suggestion above, and
even reboot my computer but it still doesn't go away.

I have posted another thread here and I think you can see the picture there.
http://www.excelforum.com/excel-gen...ick-context-menu-please-help.html#post2057001

 

[cpmame]

Wow man, you are genius. It is now gone. Do you mind telling me what went
wrong? Changing the code to FALSE will bring it back, and set to TRUE will
get rid of it. But I never saw this code when I copy & paste into VBA before.

Thanks a lot Dave

Try this in your code:

Application.ShowMenuFloaties = True

Ron de Bruin as passed it on to MS as a bug.

 

[Dave Peterson]

Not a genious.

The question came up in a different forum a few days ago. But I didn't remember
that I had seen the answer posted by Ron de Bruin--until you shared the link and
the name of the popup.

It looks like it's one of those settings that isn't available via the user
interface (there are a few of these). And you have to toggle it by code.

But the irritating thing is to hide the popup, you use true and to show it, you
use false!

Wow man, you are genius. It is now gone. Do you mind telling me what went
wrong? Changing the code to FALSE will bring it back, and set to TRUE will
get rid of it. But I never saw this code when I copy & paste into VBA before.

Thanks a lot Dave