menu items

  1. Fida_mutia

    Disable and enable one of excel functions in ribbon menu.

    Hey, I wanna know how to disable one of excel functions in the ribbon menu? And how to enable it again? For example, I want to disable the pivot table function so that I can't create pivot table in my worksheet. Also I want to know how to enable the pivot table function again. That's all my...
  2. A

    Looking for Comprehensive List of Menu Commands Rather than Just the Shortcuts

    I have found hundreds of Shorcuts like Ctrl+S for Excel 2010, but I have not been able to find a list at Microsoft for menu commands. In the case of Ctrl+S, a menu command would be Alt,F,S. I know people call them all shortcuts, but in my point of view, a shortcut is one key combination with no...
  3. E

    Context menus

    Is it possible to define custom menus when right-click is used. I have a sheet where I want to allow the user to right click on a cell and get a set of custom options. Thanks Steve
  4. BartH

    Eventhandler VBE

    Hello, In this post (http://www.mrexcel.com/forum/showthread.php?t=39411) Tom Schreiner shows us a variation on Chip Pearson's VBE explanation, to run a procedure with a custom made command in the VBE menu or toolbar. I am experimenting with this and run into the following problem: I want to...
  5. T

    Macros showing up in Tools menu

    An Excel 2003 question: I am revising a couple of spreadsheets for a client. And one thing is driving me batty. When either of the files is opened, certain VBA macros appear in the tools menu. I cannot find a macro sheet with any macro that accesses any toolbars. There does not seem to be...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top