View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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?