excel horizontol scroll bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Paste this in a standard module and run it:

Sub Macro3()
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.TabRatio = 0.5
End Sub
 
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
 
Alternatively, go to Tools--Options--View and make sure the horizontal scroll
bar option button is selected.

Dave
 
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.)
 
Hi gary - Now working....
"windows - arrange - tile" did the trick!
Thanks for your help
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vertical Scroll issue with Excel 2013 1
vertical excel scroll bar 1
Restore bottom scroll bar (Excel 2007) 4
Workbook display's title bar and right scroll bar outside Excel wi 1
How to I show the horizontal scroll bar in Excel? 2
Missing Scroll Bars 4
vertical scroll bar 1
Formatting the vertical scroll bar 1

Back
Top