excel horizontol scroll bar
 

I have totally lost the horizontol scroll bar on a previously 'just fine'
worksheet in excel 2003.
Tools for viewing have been selected properly but it still doesn't show up.
It also doesn't appear to be "collapsed" - at least, I can't see the double
vertical lines that would suggest it is just hiding. Help?

excel horizontol scroll bar
 

Paste this in a standard module and run it:

Sub Macro3()
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.TabRatio = 0.5
End Sub


--
Gary''s Student
gsnu200710


"jcinbarrie" wrote:

I have totally lost the horizontol scroll bar on a previously 'just fine'
worksheet in excel 2003.
Tools for viewing have been selected properly but it still doesn't show up.
It also doesn't appear to be "collapsed" - at least, I can't see the double
vertical lines that would suggest it is just hiding. Help?

excel horizontol scroll bar
 

Come again?? I don't know how to do this! sorry....

"Gary''s Student" wrote:

Paste this in a standard module and run it:

Sub Macro3()
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.TabRatio = 0.5
End Sub


--
Gary''s Student
gsnu200710


"jcinbarrie" wrote:

I have totally lost the horizontol scroll bar on a previously 'just fine'
worksheet in excel 2003.
Tools for viewing have been selected properly but it still doesn't show up.
It also doesn't appear to be "collapsed" - at least, I can't see the double
vertical lines that would suggest it is just hiding. Help?

excel horizontol scroll bar
 

1. touch ALT-F11 to bring up the VBA window
2. touch ALT-I
ALT-M
to bring a fresh module
3. paste the stuff in and close the VBA window (save not necessary)
4. touch ALT-F8
select the macro and run

--
Gary's Student
gsnu200710


"jcinbarrie" wrote:

Come again?? I don't know how to do this! sorry....

"Gary''s Student" wrote:

Paste this in a standard module and run it:

Sub Macro3()
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.TabRatio = 0.5
End Sub


--
Gary''s Student
gsnu200710


"jcinbarrie" wrote:

I have totally lost the horizontol scroll bar on a previously 'just fine'
worksheet in excel 2003.
Tools for viewing have been selected properly but it still doesn't show up.
It also doesn't appear to be "collapsed" - at least, I can't see the double
vertical lines that would suggest it is just hiding. Help?

excel horizontol scroll bar
 

Alternatively, go to Tools--Options--View and make sure the horizontal scroll
bar option button is selected.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Gary''s Student" wrote:

1. touch ALT-F11 to bring up the VBA window
2. touch ALT-I
ALT-M
to bring a fresh module
3. paste the stuff in and close the VBA window (save not necessary)
4. touch ALT-F8
select the macro and run

--
Gary's Student
gsnu200710


"jcinbarrie" wrote:

Come again?? I don't know how to do this! sorry....

"Gary''s Student" wrote:

Paste this in a standard module and run it:

Sub Macro3()
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.TabRatio = 0.5
End Sub


--
Gary''s Student
gsnu200710


"jcinbarrie" wrote:

I have totally lost the horizontol scroll bar on a previously 'just fine'
worksheet in excel 2003.
Tools for viewing have been selected properly but it still doesn't show up.
It also doesn't appear to be "collapsed" - at least, I can't see the double
vertical lines that would suggest it is just hiding. Help?

excel horizontol scroll bar
 

That didn't work either. I created the new module, and 'ran' , but nothing
happened. Any other suggestions? (Tools; options etc isn't making any
difference either.)

"Gary''s Student" wrote:

1. touch ALT-F11 to bring up the VBA window
2. touch ALT-I
ALT-M
to bring a fresh module
3. paste the stuff in and close the VBA window (save not necessary)
4. touch ALT-F8
select the macro and run

--
Gary's Student
gsnu200710


"jcinbarrie" wrote:

Come again?? I don't know how to do this! sorry....

"Gary''s Student" wrote:

Paste this in a standard module and run it:

Sub Macro3()
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.TabRatio = 0.5
End Sub


--
Gary''s Student
gsnu200710


"jcinbarrie" wrote:

I have totally lost the horizontol scroll bar on a previously 'just fine'
worksheet in excel 2003.
Tools for viewing have been selected properly but it still doesn't show up.
It also doesn't appear to be "collapsed" - at least, I can't see the double
vertical lines that would suggest it is just hiding. Help?

excel horizontol scroll bar
 

Hi gary - Now working....
"windows - arrange - tile" did the trick!
Thanks for your help

"Gary''s Student" wrote:

1. touch ALT-F11 to bring up the VBA window
2. touch ALT-I
ALT-M
to bring a fresh module
3. paste the stuff in and close the VBA window (save not necessary)
4. touch ALT-F8
select the macro and run

--
Gary's Student
gsnu200710


"jcinbarrie" wrote:

Come again?? I don't know how to do this! sorry....

"Gary''s Student" wrote:

Paste this in a standard module and run it:

Sub Macro3()
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.TabRatio = 0.5
End Sub


--
Gary''s Student
gsnu200710


"jcinbarrie" wrote:

I have totally lost the horizontol scroll bar on a previously 'just fine'
worksheet in excel 2003.
Tools for viewing have been selected properly but it still doesn't show up.
It also doesn't appear to be "collapsed" - at least, I can't see the double
vertical lines that would suggest it is just hiding. Help?