Teach Yourself Excel Lesson Sheet Navigation - Sheet Navigation

Is it possible to control navigation on a sheet? For example, if cells A1 and G1 are unprotected and the cells between them are protected, instead of having the user continually use the arrows to navigate, is there a way to setup the Tab key so that it will move from one unprotected cell to the next?

I have created a order form for my shirt business. My problem is: how you navigate this order form past the first row. What I mean is that A2 is the starting row and cell, a drop down menu allows you to pick a design, hit tab( i wish it was "enter" instead of tab) and you move to the next drop down, again tab to the next and so on. The problem is at the end of the row (the quantity box) when you hit enter I want the next row to un-hide and start me in cell A3, ( I have hidden rows 3 to 500 for less clutter). This should repeat at the end of each row. Any body have any ideas, I truely am a rookie with excel. Thank you.

Hi All,

I have a rather large input sheet that has nine sections, each is quite large so to simplify the process of inputs I have put nav buttons on the top of the sheet (basic stuff). When the user wants to view/change the inputs for Australia for instance, they click a button which calls this code:

*********************************************

Sub Goto_Aus()

' hide all rows except aus input range

Application.ScreenUpdating = False

Call UnhideAll_Input
Rows("56:309").Select
Selection.EntireRow.Hidden = True
Rows("22:23").Select
Selection.EntireRow.Hidden = True
Range("a19").Select
With ActiveWindow
.ScrollColumn = ActiveCell.Column
.ScrollRow = ActiveCell.Row
End With

Application.ScreenUpdating = True
End Sub

*********************************************

As you can see I'm hiding rows above and below my desired input section. The code works, although with quite a bit of flicker. I'm thinking that there has to be a better way (there always seems to be...) to choose all the rows to hide in one line, then hide them all at once... I'm also thinking that this would help reduce the flicker I'm currently seeing.

Oh, also there is a call for another macro that Unhides the entire sheet before progressing, here is the code for that sheet...


*********************************************

Sub UnhideAll_Input()

' Unhide all rows on Input Tab

Application.ScreenUpdating = False

Rows("18:378").Select
Selection.EntireRow.Hidden = False

Application.ScreenUpdating = True


End Sub

*********************************************

Would it help reduce the flicker to paste this code directly in each macro rather than calling it? When I step through the code (F8), this does "seem" to add flicker.

Thanks in advance everyone!

PZ

Hi,i have built am estimating sheet (faily basic) that has some drop down menus in it and a few cells where you have to input some data, is it possible to create some sort of message box, control box to help go through the estimating process, for instance once you complete one step it asks you or automatically takes you to the next step.

sounds as clear as mud i know but its all a bit new to me

thanks in advance

Want to go to a particular sheet in the same workbook by selecting the sheet name from a list in sheet 2 and clicking a command button. Sheet 2 has a list of all sheets in the workbook and sheet names are in two cells in column A & B (e.g. tdm-216). User to select two cells which are the desired sheet name (all sheet names are unique) and then click macro to jump to that sheet in the workbook. There will be over 100 sheets in the workbook.

At the moment i have about 5 separate sheets. At this time they are all linked by simply clicking on macro buttons which then take you to the selected sheet. For my i.t project this wont cut it. I need more exciting/different ways of navigation other than macro buttons. Could any one give me some suggestions on what this could be and how to do it (in baby like steps).


P.S if someone is feeling especially generous and could spare some time on msn (max of 30 mins) just so i can send it over and get them to play around with it - please just post here and tell me if and when they are available- tonight or sometime.. THanks.

Hello all,

Like most of you, I use excel a LOT. Is there a way to highlight the row
and column as I am navigating from one cell to another?

Cheers,
John

I have a worksheet with a lot of groups of columns representing different deals horizontally across the sheet. For example deal A is from Columns A:J, B is from Columns K:O. I can create a dropdown that will take me to a deal, but is there a way to have its locked on the screen so I can scroll across and it is always at the same spot at the top of the screen? Any other ideas other than freeze panes?

How can i put a navigation tools in the excel? below is my sample database and "search screen" with a vlookup() formula. what i want to do is that, aside from the vlookup i wanted to have a navigation tools that will explore the "database" with next, previous,first and last data. The key search is the employee number

Help please



===============================

******** ******************** src="http://www.interq.or.jp/sun/puremis/...<CENTER><TABLE cellSpacing=0 cellPadding=0 align=center> Microsoft Excel - Book2 ___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout H7 H8 =
A B C D E F G H I 4 5 Database Search with Navigation tools 6 Employee No. Employee Name Grade Employee No.: 10001 7 10001 John 89 Employee Name: John 8 10002 Jake 90 Nationality: 89 9 10003 Fiona 98 10 10006 Kathy 78 11 10007 Roane 96 12 10008 Mary Jane 74 13 Sheet1
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Dear all,

I need some help. I am developing a GANTT Chart in Excel. At the same time, I would like to use it as document navigator as well. So I can put external link to document files in the excel and people can just click on it and open the document.

This is not a problem and I did it already. The problem is that I will need to send a folder that contains the excel file and all the documents linked to it to people.

Therefore, I will need it to update it automatically and anchor the link only to the main folder, without referencing to my hard drive.

Is this even possible? Thanks in advance for any of your suggestion!

Cheers!