Excel - Disabling Menu Floaties inside cell.

Sach44
Sach44 used Ask the Experts™
on
I disabled the right click context menu floaties using " Application.ShowMenuFloaties = True ".

However, I would like to know if the IN CELL menu is possible to disable :

Sans-titsss.png
I am aware I can use a hidden textbox or combobox to disable the possibility of acccessing this menu as well. Is there a simple fix for this?

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Go to Excel, Options, Advanced and look through the options.

Down in Display, uncheck function tips, select no comments and indicators.

This is where you find what you want, and you need to try one at a time to see how it might help you.
Here is how you can disable in cell Menu Floaties.
Application.ShowSelectionFloaties = True
Application.ShowMenuFloaties = True

Open in new window


Or Put this in the immediate window and press enter. Now all floaties are disabled.

Shortcut to Immediate Window is Ctrl + G

Application.ShowMenuFloaties = True

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial