How to hide the sub popup menu

[levanduyet]

Dear All,

When I right-click on the excel sheet, I get the menu as the following picture:



How I write the code to hide the sub popup menu (1)?
I use Excel 2007.

Tks,

LVD

[GTO]

Greetings :-)

Say, I hate to ask a question when I have absolutely no help to give, as I believe you must have 2007 (and I do not).

Anyways, if not a bother, how did you get that style (the tore edges and all) of screenshot?

Mark

[Charlize]

If it's for a certain worksheet, change the beforerightclick-event of the worksheet.

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

If it's for all the worksheets in the workbook, use this

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

Charlize

[Bob Phillips]

I think he wants to hide just the formatting task pane.

[levanduyet]

Dear CharLize,

I just want to hide the popup menu 1. Pls see the picture. (not the normal popup menu like in Excel 2003). The popup menu that I want to hide is the popup menu regarding font, font size, aligment,...

Tks,

LVD

[Digita]

Hello Duyet,

I don't use XL 12 often so don't have an answer for you. However, this link may help.

Regards

[levanduyet]

Hello Duyet,

I don't use XL 12 often so don't have an answer for you. However, this link may help.

Regards

Thanks Digita,
The link that you given to me, it discuss about difference object.
Anyway, thank you.

LVD

[Ken Puls]

I believe that the code you're after is:

Application.ShowMenuFloaties = False
Application.ShowSelectionFloaties =False

In my tests here, though, it doesn't actually do anything. In fact, I still get the mini toolbar even after going into Office-->Excel Options-->Popular and un-checking "Show Mini Toolbar on Selection"

Hope it works on yours,

[mdmackillop]

Doesn't do anything for me either Ken.

[Ken Puls]

Malcolm, do the manual steps to disable it work for you?

[mdmackillop]

No,
I thought mini toolbar would be the way to go, but I couldn't see what it did (or was meant to do)

[Ken Puls]

It's weird. The steps in the UI that you can do manually do turn off what I believe are the "selection floaties" I can actually see the difference there, although it's more obvious in Word than Excel. I would have expected that the "menu floaties" would have hit the menus. I'm wondering if there is a bug there, or it just something different that I'm not seeing.

[Ken Puls]

Oh, this is bizarre... Ron de Bruin worked it out:

Application.ShowMenuFloaties = True

Sounds to me like someone messed that up, but it works!

[mdmackillop]

Who would have thunk it?