menu

I have a table with a series of hyperlinks that I am using to trigger a macro for hiding/unhiding certain rows. Cell C3 contains the main menu, when it is clicked a collection of sub menus headings become unhidden in rows 6, 78, 155, 177 & 354. In turn, when each of the sub menu headings are...

Win 7 Access 2007 Rather than creating a menu is it possible to import a menu from another .mdb? tia Jack

Hi all, Hopefully someone can help. I have the following code (part of a bigger piece of work) and until I started using 365 worked fine. Now I receive a runtime 13 error and I cant for the life of me figure it out other than it may be something to do with the adding a menu bar item or...

I'm trying to write some code to cause the ribbon to disappear and also try to get the menu to disappear on startup. I can get 'CommandBars.ExecuteMso "MinimizeRibbon"' to work just fine anywhere EXCEPT the WorkBook Open event. Any ideas for this and to hide the Excel menu on startup?

Hello everybody. In navigating a site with vba, I'm stuck on a menu. button id="z1xxx-b" class="z-menu-btn" type="button">Report </button> a id="z1yyy-a" class="z-menu-item-zzz" href="javascript:;"> My attempt: Dim links, link Dim j As Integer...

I'm a complete novice with VBA codes, I've added the below to hide columns based on a drop down menu but I also want to hide tabs based on the same drop down menu but have no idea how, any ideas? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Target.Row = 3 And...

Hi, I'm curious whether it would be possible (likely VBA) to allow a cell's value to either update a range to mirror the value of a cell or to insert a drop down menu into each cell in the range. Specifically, I have a dropdown menu in B1 that allows for three options. If Option1 or Option2 is...

Hi There, I was wondering if you could help me out with a Macro i desperately need to easy my work. I have a sheet with 2 drop-down menus and a bunch of tables underneath. 1st dropdown menu represents 1 criteria - example REGION . 2nd dropdown menu represents 2nd criteria - different customers...

Hello, I am new to the thread and relatively new to Excel. I have a job log spreadsheet and I have created a drop down menu to indicate whether the job is open or closed. As we have a fair amount of jobs, once the closed option has been selected I want to hide that row. I have researched it...

I have a file where I need to print the pages from last to first. We're using Excel 2013 and Xerox Phaser 7500 printers. Is there a way to specify this either from the Excel print menu or from the printer options? I could do it using VBA but I'm hoping there's something more obvious. TIA

Hi, Is it possible to enable a right click custom context menu by Selection?. I can grey out the menus/buttons on workbook open, I have a feeling selection change event will be needed. Can anyone help me with this

When I hit alt-F8, the menu will sometimes display macros for "All Open Workbooks" and sometimes show only macros for "This Workbook." Is there a way to set the default to display only macros for the current workbook?

I am trying to get to the login screen and automatically enter the username and password and clicking on Enter. I have been successful on other sites but the following site has a "Login" button that functions as a dropdown menu. I can't figure out how to navigate past the dropdown menu to get...

Hello Everyone, so I want a specific area to be always visible on screen for the user of my spreadsheet. I am creating a macro driven Excel tool and have placed buttons and output cells in the top rows of the sheet. This "menu" that I want to be visible and accessible at all times is placed on...

I have a dropdown menu. When a selection is made from the dropdown menu, I input information into specific cells (A10,A12,A14,A15,A16,A18,A20,A22,A24,A26,A28). So if I fill out information in those cells and then come back to that selection later, I want all the cells to load back up with my...

Hello Excel Experts I'm trying to set up some drop-down menus, with the first one determining what will show in the second one. The first one (and I'll use the actual cells in my sheet so I don't get confused), located in cell E15 will show a range of numbers from 1 to 10 - defaulting to 1. The...

I have an excel template that I would like to open with a main menu... each menu pointing to a sheet (10 in total) 3 of which are password protected. Sales Costing sheet (password protected) Costing work sheet (password protected) Bom Cut sheet Drawings Production Qc Shipping Employees...

Experts: I need your help with creating a conditional name range. Here's what I have thus far. Cells A1:A10 are saved as name range "Customers". I then use that name range...