LIST Button - Removing Arrow that goes left to Right
 

How do I get rid of the arrow that scrolls left to right. I just want one
arrow that goes up & Down

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1

LIST Button - Removing Arrow that goes left to Right
 

ActiveWindow.DisplayHorizontalScrollBar = False

LIST Button - Removing Arrow that goes left to Right
 

Where do I place this code in the Form??

Greg Glynn wrote:
ActiveWindow.DisplayHorizontalScrollBar = False

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1

LIST Button - Removing Arrow that goes left to Right
 

This did not work. I have a list command button in a form


Greg Glynn wrote:
ActiveWindow.DisplayHorizontalScrollBar = False

--
Message posted via http://www.officekb.com

LIST Button - Removing Arrow that goes left to Right
 

On Mar 14, 5:17 pm, "Fredriksson via OfficeKB.com" <u27002@uwe wrote:
Where do I place this code in the Form??

Greg Glynn wrote:
ActiveWindow.DisplayHorizontalScrollBar = False

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200703/1

You can use that code in a macro. Tools--Macro--Macros--type a
name--create--paste that code into the current position in VB. Exit.
Go back to the Macros window, click your new macro, click options,
make a shortcut key for it and you can use that shortcut key to turn
them off. You can similarily use the same principles to turn the
horizontal scroll bar back on, except of course using true instead of
false.

if you want to turn them off all the time i supposed you could just
turn them off under tools -- options

LIST Button - Removing Arrow that goes left to Right
 

Make the ListBox wider or the ColumnWidths narrower.

Hth,
Merjet

LIST Button - Removing Arrow that goes left to Right
 

Thanks
merjet wrote:
Make the ListBox wider or the ColumnWidths narrower.

Hth,
Merjet

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1