worksheet won't advance in Excel

February 27, 2012 at 09:24:09
Specs: Windows 7
tab scrolling buttons will not advance the worksheet
I've turned them off and don't know how

See More: worksheet wont advance in Excel

Report •

#1
February 27, 2012 at 11:58:12
tab scrolling buttons

Not sure what you mean.
What version of Excel are you running?

MIKE

http://www.skeptic.com/


Report •

#2
February 28, 2012 at 06:00:16
The scroll button at the bottom left corner of the page that control the worksheets do not work.

Report •

#3
February 28, 2012 at 11:46:08
How many sheets do you have?
You need more than just 3 or 4 for it to kick in.

If you think you have disabled them, then try:

In 2007:
Open the Office button.
Click Excel Options (in the bottom right corner).
Select Advanced.
Scroll down to the Display Options In This Workbook section.
Check the Show Sheet Tabs option.
Click OK.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
February 28, 2012 at 12:37:53
2007
I had 7 sheets open and I can see them, but they don't move when you push forward or back.

Report •

#5
February 28, 2012 at 12:51:56
On my 2007, the tab scrolling only works
if the number of tabs or the length of each tab
causes it to push behind the screen slider bar.

MIKE

http://www.skeptic.com/


Report •

#6
February 28, 2012 at 13:45:24
Thanks not what I wanted to hear, but thanks for taking the time. I was trying to create a macro to select the next sheet forward or back without having see or click on them one at a time. Just use some created buttons on a form.

Report •

#7
February 28, 2012 at 14:32:24
I was trying to create a macro to select the next sheet forward or back without

You never mentioned you wanted a Macro.

That can probably be done, but not by me.
My VBA skills are just above nill.

Perhaps someone else will offer a solution.

MIKE

http://www.skeptic.com/


Report •

#8
February 28, 2012 at 14:43:54
Sorry I just wanted to create a macro and select the scroll buttons below and attaching it to a button. That's how this whole thing started. I do appreciate the help, even though it was my own ignorance.

Report •

#9
February 28, 2012 at 15:34:32
select the scroll buttons below and attaching it to a button.

Isn't that a bit redundant. Attaching one button to another button.

You do know that you can right click on the tab scroll buttons
and it will give you a list of all your sheets.
You can then just select the one you want.

If you really want a macro, look here:

http://www.mrexcel.com/forum/showth...

MIKE

http://www.skeptic.com/


Report •

#10
February 29, 2012 at 08:42:10
I would seem so, however if you saw the form you would see the logic. It's locked to guide them to a solution based what they select.

Report •

#11
February 29, 2012 at 09:52:01
I would seem so, however if you saw the form you would see the logic.

Well, we can't offer much more assistance, unless you decide to tell us "the whole story", because from where I'm sitting, I can't see your workbook. ;-)

MIKE

http://www.skeptic.com/


Report •

#12
March 1, 2012 at 13:05:31
If I could post a pic I would. Thanks for the tip on the macro works grear.

Report •

#13
March 1, 2012 at 14:08:13
Post a picture at a free hosting site such as Photobucket and then post the link here.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question