The problem is i can ONLY use it the way I mentioned in my first post, If i
click on either arrow to go to next page or previous or the arrows for first
page and last page Nothing happens, Excell does NOT go anywhere, It acts as
if the arrows weren't even there other than the fact that I CAN right click
on them and switch sheets that way.

"Tom Hutchins" wrote:

Is this what you mean? Right-click on the navigation bar to pop up a list of
all the visible sheets in the workbook. You can use the arrow keys and Enter
to select a sheet from this pop-up menu.

Also, you can use the navigation bar as you described; you can click on the
desired sheet tab; you can use CTRL+PAGE UP to move to the sheet to the left
of the active sheet and CTRL+PAGE DOWN to move to the sheet to the right of
the active sheet; and you could use a hyperlink or macro to move to a
different sheet. There are probably more I haven't remembered.

Hope this helps,

Hutch

"cmazurski" wrote:

I can left click and choose a worksheet at the navigation bar but I cannot
use the arrows to move either between worksheets or to the first or last
worksheet