| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding scroll bar to scroll on cell's content? | Charts and Charting in Excel | |||
| vertical excel scroll bar | Excel Discussion (Misc queries) | |||
| Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
| Scroll the screen view with the scroll bar | Excel Discussion (Misc queries) | |||
| Scroll Bars Do Not Appear in Excel XP | Excel Discussion (Misc queries) | |||
Linear Mode
