menu

Why do I not see ANY macro's in the left image while I do see macro's in Alt+F11???? This goes for all my workbooks. I have restarted, repaired Office; checked all Trust settings... no clue.

Hi! I've just been Googling excel forums trying to find a way to do this. I just want to make a cell auto-populate a body of text based on a dropdown menu selection. I know how to do that, though... However, I want to be able to EDIT the text that populates...and I DON'T know how to do that...

Hello everybody, I have a userform, for which I have specified the (Height = 720) & (Width = 1280) properties from the Properties panel. And I have made a Jpeg in Photoshop which is intended as a sidebar menu background in my userform and it's (Height = 720) and (Width = 190) Now, one would...

@Jaafar Tribak - I have seen that you have extensive experience in this topic so I am hoping that you can help me please. I have an external application that I can launch and control from Excel, but only up to a point. As soon as I click on the SEND TO button and the menu pops up I can't go...

Hi, all! I've got a calendar-style sheet (sheet 3) that I'm pulling data from, and I've got the categories in 2 different dropdown menus on a second sheet (sheet 4). I'm trying to get a cell to add up all of the occurrences of certain text within the calendar. I've figured out how to...

Hi! I am looking for a code that will create a popup menu that appears when a user opens the workbook. The menu would have 4 choices and each choice would unhide a different set of tabs. Below are the menu names and tab combinations. I'm not even sure where to start. TIA!!! Menu Option...

Hi I am watching the video below and in minute 2:00 he went to Window tab in the menu to find out which excel files are opened. I am using office 365, where I can find that option? Thank you very much. https://www.youtube.com/watch?v=-foPogO3QNE

In previous versions of Excel I was able to tab into the chart formatting menu that popped up and use the alt keys to jump to the functions with underlined letters. Now when the menu pops up along the side of excel I haven't figured out how to tab into it or use those same shortcuts. Is there...

If I wanted to replace all the 456 items in the column below, then the delete blank rows where the 456 items were, what menu do I use? <tbody> 142 996 456 123 456 226 456 225 456 </tbody>

Hi, When I right click on a cell I get a drop down menu and a box containing tools above or blow it, I would like to customize this box of tools and the drop down menu also, is this possible. Thanking you in advance. Regards, Duncan.

Is it possible to have the name in the list show up on the sheet without the underscore? I have a dropdown menu in a cell which dictates what shows up in a drop down menu of another cell. I don't like how it looks with the underscores... is there a fix, or do I need to get over the cosmetics...

Hello all, I have searched and searched but I have not found a thread covering this particular problem. Historically, when I have double-clicked the lower right corner of a cell, it will automatically autofill the cells below and offer a fill handle option menu (Copy Cells, Fill Series, Fill...

I have a macro that will be run several times throughout a worksheet. First time I run macro it will fill column AF down to a certain # of rows based information in column A. Lets say in this case row 20. Then if we need to add more rows below this, I want to re-run the macro so it will...

Hi, I have not used VBA in months and my first task back is trying to create a menu page which will have a data validation drop down with multiple selections on there which I want to link too certain sheets. So when selecting "test" from the drop down list then it will take me to the "test"...

Hi All, I am attempting to create a spreadsheet and would like to know if it is possible if somebody selects "yes" from a drop menu options of "yes/no" that the row is automatically copied from one worksheet to another that is password protected? I want the first sheet to accumulate the workflow...

If I use Shift+F10 for any selected FormControl/ActiveXControl/Shape, the correct context menu appears. But if I right click the object, I get a menu that reads : Move Here Copy Here Cancel Anyone know how to fix this?

Greetings, is it possible to have (3) dropdown lists equal a dollar amount? Task at Hand: I will try to simplify to help make sense. Let's use a restaurant menu as an example. Depending on your order and the options chosen, the total will be different. Dropdown list 1: Types of meat-Chicken or...

We have a program we use for some work, its a exe file that runs in a dos window. It starts with a menu of 5 choices, and I would like to use excel to populate the menu choices, and also other operations. Is this something excel can do, or is there a better way? It would involve opening files...

I do a lot of coding for the event right-click. I end my additional steps with Cancel=True which used to always avoid popping up the incell menu. Now, for the past many months, the cancel=true seems to no longer work and I get an annoying right-click menu that pops up after my code executed...

I'm trying to import some text from a CSV file, but I don't want to include the headers, which the CSV file contains. I've been told on a previous thread I posted that there's a "start import at row" option where you can select the topmost row to import. That thread seems to have died a few days...