Scroll Bar Disappears

C

Chris Davison

MrExcel MVP

Joined

Feb 15, 2002

Messages

1,790

• May 5, 2002

• #2

see if they've been hidden :

tools
options
view

horizontal scrollbar = checked ?
sheet tabs = checked ?

 

Upvote 0

J

James

Active Member

Joined

Feb 17, 2002

Messages

327

• May 5, 2002

• #3

CT,

Click on Tools>Options>View, and make sure you have the scroll bar and sheet tabs checked

James

_________________
This message was edited by James on 2002-05-05 16:27

 

Upvote 0

C

Chris Davison

MrExcel MVP

Joined

Feb 15, 2002

Messages

1,790

• May 5, 2002

• #4

also try :

view
fullscreen

this can chop them off also, although you'd notice your toolbars n things going awol also so it's probably not that

 

Upvote 0

Anne Troy

MrExcel MVP

Joined

Feb 18, 2002

Messages

2,632

Office Version

1. 365

Platform

1. Windows

• May 5, 2002

• #5

Another thing that can occur:

The file window gets moved around inside the program's window.

Hit Window-Arrange, and hit OK. Then maximize the file window by using the restore button.

 

Upvote 0

C

Creative Type

New Member

Joined

May 2, 2002

Messages

3

• May 5, 2002

• #6

Thanks so much for responding...I think I am going to be using this web site a lot. I barely know Excel and just started a new job that is going to require extensive Excel work. Thank you for answering my post!

 

Upvote 0

Anne Troy

MrExcel MVP

Joined

Feb 18, 2002

Messages

2,632

Office Version

1. 365

Platform

1. Windows

• May 5, 2002

• #7

Welcome, CT. One of the great things about sites like this is that you can search through the previously asked questions. If you found that one of these replies worked for you, it's helpful to someone who searches to know WHICH one. You'll be able to save them some time, and also *give a little bit back* to the site.

 

Upvote 0

K

KWMKWM

New Member

Joined

Jun 3, 2010

Messages

12

• Sep 15, 2010

• #8

Anne Troy's response worked for me in Excel 2010, select VIEW/ARRANGE ALL <ARRANGE All>from the ribbon and then check WINDOWS OF ACTIVE WORKBOOK. <WINDOWS workbook active of>

 

Last edited: Sep 15, 2010

Upvote 0

A

akino25

New Member

Joined

Oct 27, 2011

Messages

33

• Mar 15, 2012

• #9

James said:

CT,

Click on Tools>Options>View, and make sure you have the scroll bar and sheet tabs checked

James

_________________


[SIZE=-1][ This Message was edited by: James on 2002-05-05 16:27 ][/SIZE]

Click to expand...

When I open Excel and activate the macro, my scroll bar vertical and horizontal just disappear... and in tools option it was not checked. So I check it back and it is there and works fine. However I have to do this everytime. can anyone help with this? We normally shouldn t have to check those box every single time...

 

Upvote 0