There are two context menus which pop up when a cell is right clicked
in excel 2007 and 2010. The topmost appears to be a cell formatting
menu. I do not wish to have users edit the formatting in the cells, so
I would like to disable that menu.

I have been able to delete all the menu items in the second pop-up
menu, but how to do it in the first has eluded me.

I would appreciate any help offered.

Thank you.

On Sat, 22 Jan 2011 12:24:31 -0500, wrote:

There are two context menus which pop up when a cell is right clicked
in excel 2007 and 2010. The topmost appears to be a cell formatting
menu. I do not wish to have users edit the formatting in the cells, so
I would like to disable that menu.

I have been able to delete all the menu items in the second pop-up
menu, but how to do it in the first has eluded me.

I would appreciate any help offered.

Thank you.

Found it, but the syntax does not seem logical...

Application.ShowMenuFloaties = True to hide the Mini Toolbar
Application.ShowMenuFloaties = False to show it.

I believe the summer intern had to have something to do and that's what she turned in.
It gets even better; to toggle it use...

Application.ShowMenuFloaties = Application.ShowMenuFloaties

'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(XL Companion add-in: compares, matches, counts, lists, finds, deletes...)





wrote in message
...
On Sat, 22 Jan 2011 12:24:31 -0500, wrote:

There are two context menus which pop up when a cell is right clicked
in excel 2007 and 2010. The topmost appears to be a cell formatting
menu. I do not wish to have users edit the formatting in the cells, so
I would like to disable that menu.

I have been able to delete all the menu items in the second pop-up
menu, but how to do it in the first has eluded me.

I would appreciate any help offered.

Thank you.

Found it, but the syntax does not seem logical...

Application.ShowMenuFloaties = True to hide the Mini Toolbar
Application.ShowMenuFloaties = False to show it.

brought next idea :
On Sat, 22 Jan 2011 12:24:31 -0500, wrote:

There are two context menus which pop up when a cell is right clicked
in excel 2007 and 2010. The topmost appears to be a cell formatting
menu. I do not wish to have users edit the formatting in the cells, so
I would like to disable that menu.

I have been able to delete all the menu items in the second pop-up
menu, but how to do it in the first has eluded me.

I would appreciate any help offered.

Thank you.

Found it, but the syntax does not seem logical...

Application.ShowMenuFloaties = True to hide the Mini Toolbar
Application.ShowMenuFloaties = False to show it.

Jim's reply handles the "floaties" menus. Not sure why you'd go to the
trouble of deleting all the menus on the "Cell" popup when you could
just set its 'Enabled' property to "False" to prevent it from showing.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Note that setting...

Application.Commandbars("Cell").Enabled = False

also disables the 'floaties' menus.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Sat, 22 Jan 2011 19:23:35 -0500, GS wrote:

brought next idea :
On Sat, 22 Jan 2011 12:24:31 -0500, wrote:

There are two context menus which pop up when a cell is right clicked
in excel 2007 and 2010. The topmost appears to be a cell formatting
menu. I do not wish to have users edit the formatting in the cells, so
I would like to disable that menu.

I have been able to delete all the menu items in the second pop-up
menu, but how to do it in the first has eluded me.

I would appreciate any help offered.

Thank you.

Found it, but the syntax does not seem logical...

Application.ShowMenuFloaties = True to hide the Mini Toolbar
Application.ShowMenuFloaties = False to show it.

Jim's reply handles the "floaties" menus. Not sure why you'd go to the
trouble of deleting all the menus on the "Cell" popup when you could
just set its 'Enabled' property to "False" to prevent it from showing.

I knew after I posted this question that I hadn't provided enough
information. My error.

I suppose if I'd been more specific by mentioning I had created menu
items for the right click event I would have answered that question
before it was asked.

Enabled = False also turns off my menu.

I knew after I posted this question that I hadn't provided enough
information. My error.

I suppose if I'd been more specific by mentioning I had created menu
items for the right click event I would have answered that question
before it was asked.

Enabled = False also turns off my menu.

No you did not create menus for the right click event! What you're
saying is you 'modified' the "Cell" menu with your own menus. IOW, you
did not create your own right-click menu, which is a more appropriate
approach than modifying built-in menus when you don't intend to use any
of them. It's also easier to do than all the work you had to go through
to fenagal doing it the way you have.

To replace the built-in "Cell" menu with your own popup you merely need
to put code in the Workbook_SheetBeforeRightClick event to display your
menu and cancel Excel's. No fuss, no muss, no messing around with
modifying built-in menus or deleting menu items, nothing to reset or
undo when your wkb closes! (You do realize the built-in menus remain in
whatever state you put them when your wkb modified them, -right?) Now,
doesn't that seem easier to you?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Sun, 23 Jan 2011 13:48:43 -0500, GS wrote:

I knew after I posted this question that I hadn't provided enough
information. My error.

I suppose if I'd been more specific by mentioning I had created menu
items for the right click event I would have answered that question
before it was asked.

Enabled = False also turns off my menu.

No you did not create menus for the right click event! What you're
saying is you 'modified' the "Cell" menu with your own menus. IOW, you
did not create your own right-click menu, which is a more appropriate
approach than modifying built-in menus when you don't intend to use any
of them. It's also easier to do than all the work you had to go through
to fenagal doing it the way you have.

To replace the built-in "Cell" menu with your own popup you merely need
to put code in the Workbook_SheetBeforeRightClick event to display your
menu and cancel Excel's. No fuss, no muss, no messing around with
modifying built-in menus or deleting menu items, nothing to reset or
undo when your wkb closes! (You do realize the built-in menus remain in
whatever state you put them when your wkb modified them, -right?) Now,
doesn't that seem easier to you?

No, actually...I didn't consider that. I had reset the menu in an
'auto' module instead. I'll give your advice a look. Thanks.

You could steer me in the right direction with a code snippet that
demonstrates a popup menu.