excel horizontol scroll bar

J

jcinbarrie

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?
 
G

Gary''s Student

Paste this in a standard module and run it:

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

Gary''s Student

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
 
D

Dave F

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

Dave
 
J

jcinbarrie

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.)
 
J

jcinbarrie

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