menu

Keyboard shortcuts doesn't work when the menu bar is not visible Version: Excel for Office 365 MSO (16.0.10730.20264), 64 bit I'm an avid user of key-board short cuts. First thing I think of for Save=Ctrl-S, Copy/Paste=Ctrl-C/V, Set filter= Ctrl-Shift-L etc. So if I want to delete a row or a...

I have a context menu that shows when the user right-clicks on the worksheet. When I added a 10th item to it, the menu option shows up but it will not call the sub that calls the module that writes the report. Checked the syntax and created a breakpoint at the menu item being called for both the...

Hello Everyone, I know it's possible to have conditional formatting with a dropdown menu. Now I want this without taking over the value of the drop down menu. For example: Cell A3 contains the value "Project 1". Also cell A3 has a dropdown menu with three options: "Not stared", "In progress"...

Hi, I'm wanting to run macros on files I use often I know an option is to save them all to Personal.xlsb but I would prefer to have them in a ribbon tab, has anyone done this ? Ideally in a drop-down menu ( similar layout to PageLayout > Colors menu)

Hi, Is there code to show the print screen as if you went to file and print from the menu? I tried the "(xlDialogPrint).Show", but that doesn't show all of the options such as fit to page, landscape, etc. Thanks

So MS has renamed the old Comments to Notes, and the new Comments have become threaded conversations. We're now using Notes in the same manner as we used to use Comments. The problem is, EDIT NOTE nor NEW NOTE appear in the right-click menu when in a cell that has a Note, only DELETE NOTE. Is...

hi guys i have the following link https://www.dropbox.com/s/m5b64du6v5ioy0f/rollover.xlsm?dl=0 I have tried to modify the existing file but it is not working. Infact there are four menus(Collateral Unit,Documentation, Filter, Extract). When the collateral menu is selected , the sub menu...

Hello, I have a VBA code for a worksheet help me to increase the window zoom when I select the drop down menu. With this code I can see the drop down menu text in appropriate font size. Here is the code: Private Sub Worksheet_SelectionChange(ByVal Target As Range)...

Hello - I am at a loss. I have an Add-In I created some time ago and recently used Andy Pope's RibbonX Visual Designer in order to add it to my Ribbon. By the way, AJP's RibbonX Visual Designer is AWESOME!! Anyway, I decided to add a couple of the Add-In commands to the cell menu. Now, when I...

Hi I have a spreadsheet containing a dropdown menu There has never been an issue using it in the past, however we have recently upgraded to 2016 and when i click on it now the drop_down arrow quickly appears then disappears again. In other tabs within the same spreadsheet , the dropdowns all...

Hey. I was editing a file recently and wanted to include a dropdown menu for other people to open and be able to choose some options. When I reopened the file later, clicking on the dropdown menu did nothing, and it was impossible to delete. It just hovers there now and this file is so far in...

I am interested to know which are the most useful Excel templates for such tasks as menu planning and managing household accounts and finances.

I have some drop-down menus, but when the a presses DEL and clears the field - it is messing up my formulas. How can I pre-set the drop-down menu to show [%] whenever the DEL button is pressed? Thanks Ryan

Hi I need help to sum a row of data based on a drop down menu "fortnight from" AND a drop down menu "fortnight to". Range: B3:G3 = numbers to sum Range: B2:G2 = Fortnight #1 , Fortnight #2 etc Cell: B15 is drop down menu to "Select Fortnight from:" Cell: B16 is drop down menu to "Select...

My spreadsheet is getting too cluttered with buttons, menus, text boxes, etc. Is it possible to create a custom popup menu that contains multiple form/ActiveX controls and appears when the user clicks a button on the spreadsheet? I found this basic tutorial here...

How can i bring up the old excel 2010 web query menu in excel 2016, the one with the wee yellow arroes to select the part of the web page you want. I did it once before with keyboard shortcuts but cant find it again Many thanks I think if i use this and log in, PQ is able to access page

Sub Add_Menu () With Application.CommandBars("cell") .Reset With .Controls.Add (Tpe:=msControlButton, temporary:=False) .Caption = "Menu 1" .OnAction = "Men1" End With End with End Sub Above is code I used to add menu on...

Having strange Excel issue. Open Excel and choose a standard workbook. Right click the mouse and there is no menu available. Open an existing workbook and there might be a right click menu or not. There does not seem to be a pattern. I can easily enable the menu with a Commandbars routine, but...

Can it be done? I have a Userform with several combo-boxes, I want to know if it's possible to display the combobox dropdown menu by clicking on the actual combobox rectangle, not just on the dropdown arrow key... Does it make sense?

Hi all, Is it possible to link a filter to a list to get the table to show only the items in the list Currently I am ticking them on the drop down menu Many thanks