MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Scroll bar code

Posted by Mike K on July 17, 2000 5:27 AM

what is the code to remove the scroll bar for VBA?? thanks

Posted by Ryan on July 17, 0100 5:49 AM

This removes the horizontal bar
ActiveWindow.DisplayHorizontalScrollBar = False

' This removes the vertical bar
ActiveWindow.DisplayVerticalScrollBar = False