Excel 2007 minitoolbar turn off question?

[boe]

Hello,

I'm running excel 2007. I went to options and turned off the minitoolbar
under popular (unchecked now) but when I right click on a cell it brings up
a tiny formatting toolbar. I've saved those settings exited excel - gone
back in that box is still unchecked but the box still mini formatting
toolbar still appears. How do I turn that feature off please?

 

[Jim Rech]

Excellent question. I don't know what that option does (when does a
'selection' mini-toolbar appear?) but you have to turn off the menu
mini-toolbar to affect the right click menu. The only way I know to do that
is in the registry. Run Regedit.exe from Start->Run and go to:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Toolbars\Excel

Right click in the right panel and select New and DWORD Value. Name it
AllowMenuFloaties and leave its value at 0.

 

[boe]

Thanks - I'll give that a try!

Excellent question. I don't know what that option does (when does a
'selection' mini-toolbar appear?) but you have to turn off the menu
mini-toolbar to affect the right click menu. The only way I know to do
that is in the registry. Run Regedit.exe from Start->Run and go to:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Toolbars\Excel

Right click in the right panel and select New and DWORD Value. Name it
AllowMenuFloaties and leave its value at 0.