navigation

Have just recently upgraded from 2010 to 2013. I notice with 2 books open that when I attempt to click within the foreground workbook that my cursor lands on a background workbook. Repeatedly. I generally Alt-tab between to navigate. The only way to make contact with the correct book is to...

Hi, I want to go to a specific record in a form if I type in a 'Date' and filter two combo boxes with the 'Team name' and 'Code'. Each record in the form has the 'Date' in a text box and the 'Team name' and 'Code' in separate combo boxes. I want to view the search result in form view and...

Hello, I asked this question in 2012 and didn't get a solution so I'm hoping that somebody will be able to help me 4 years later. I would like to have a "PREVIOUS" navigation button in a workbook that goes back to the previously activated worksheet, which may or may not be physically the...

I am having problems with this code which extracts solar data from a public website that requires a registration and login. The situation is as follows: 1. The code navigates to the website successfully, enters the usercode and password, and logs in. Logging in results in a total change...

I have a userform with two buttons. butNext and butPrev. I was wondering if it is possible to navigate to the adjacent worksheet using these buttons respectively. Thanks!

Have a navigation tab with a bunch of box shapes. I want to make it so that when the user clicks each shape, it takes them to the tab that has the same name as the text written in the shape. I realize I can do this by writing a separate macro for each individual shape, but is there a universal...

I have a workbook with a bunch of formulas and linked workbooks. While I check the various formulas, I use the quick keys crtl + [ to see where the formula is referencing. The problem I'm having is it will switch to another sheet or workbook and I have to find the original cell I was looking...

Ciao All ~ Not sure which forum to drop this question into, but here goes ... I'd like the end user to select from 100 different locations. When a selection is made the sheet will "shift" to the appropriate row on the worksheet. Is it possible to use Data Validation to navigate a list of...

Hello, I have developed a very long worksheet, with many sections that can be collapsed and expanded with outlining. I had an idea to add a "worksheet navigator" section at the top of the page, and maybe a button or dropdown menu within each section, to make it easy for the user to quickly...

Hi I have a 'dashboard' worksheet in 2010 and want to be able to click on a cell in this sheet and have it take me to the assigned worksheet. They are all in the same workbook. e.g if i click on Leadership i want it to take me to the Leadership tab, Skills to take me to the Skills tab etc The...

So what i have is about 50 sheets all formatted generally the same that contain various bits of info on products. On one sheet i have the list of all the products by Code# and they're all hyper-linked to the corresponding sheet. at the top of all the other pages is a button to bring you back to...

I would like to have a "PREVIOUS" navigation button in a workbook that goes back to the previously activated worksheet, which may or may not be physically the previous worksheet in the workbook. In other words, if I go from Sheet #1, to Sheet #3, to Sheet #5, I'd like to return to Sheet #3 from...

Hi: On my worksheet (Excel 2007), the user will be entering data in both cells and combo boxes. Each time he enters info in a cell, he hits enter and the cursor moves to the next cell; however, if there is a combo box positioned over a cell, I would like the cursor to move into the combo box in...

Hi all, I'm after a work around to select all ranges in a formula. ie When you click into the formula bar & all the ranges are surrounded by boxes & you can move, resize etc. When there are several boxes around the same range is it possible to move/resize all the boxes for that range instead...

Ctrl+PgDn normally takes you to the next worksheet If a worksheet is unprotected, or protected with all cells locked, this works fine. If a worksheet has a mixture of locked and unlocked cells and is protected with "select unlocked cells" allowed, Ctrl+PgDn works differently and moves you across...

Hi All, Does anybody know if there is a way to prevent a user from navigating between worksheets by clicking the tabs at the bottom? I have a workbook that has "Next" and "Back" buttons to jump between worksheets, and I want to prevent users from being able to over ride it by clicking the tabs...

Hello, I have a 2003 spreadsheet with multiple pages and am trying to create navigation buttons (back and next) to move between the sheets. I'm trying to think of a way to have an image used as a button with over/up/down states and run a macro on click. The nearest I can get is using a...

Does anyone have an idea how to read the emails into excel I am stuck In the sourcecode from the inbox it reads something about the readpanel is "hidden" Anyway, I can loop threw the inbox and display the ones I am interested in, but I can not pull the data from within the email I hope...

Does anyone have an idea how to read the emails into excel I am stuck In the sourcecode from the inbox it reads something about the readpanel is "hidden" Anyway, I can loop threw the inbox and display the ones I am interested in, but I can not pull the data from within the email I hope...

Hi guys, I have read many threads about members trying to navigate their way around workbook sheets by using a Combobox. There seems to be many alternatives but not a simple solution, can anybody help please? My problem is this: I have 10 sheets (Sheet1 to Sheet10) I would like to have a...