Scroll Bars

[Paleo]

Is there a way to hide the scroll bars? Vertical and horizontal?

[Ken Puls]

Hi Carlos,

Check Tools|OPtions. Recording a macro while unselecting. :*)


With ActiveWindow
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
End With

[Ken Puls]

And by the way... same caveats apply as here (http://www.vbaexpress.com/forum/showthread.php?t=1733) when locking down the user interface.

Cheers,

[johnske]

Hi Paleo,

You can also do vertical and horizontal in one go with


Application.DisplayScrollBars = False

John

[Ken Puls]

Nice! Thanks John!

[Paleo]

Hi guys thanks. I agree with you Ken but I was asked to do that and simply didnt know how.

[johnske]

Just remember to always leave an escape route when playing around with the user interface...

I once played around with it and completely forgot that what I was doing affects ALL the application and not just the active book, and ended up with just a blank white worksheet that had a narrow border and nothing else - no tools, no VBE window (so no way to get back into the code-pane and undo it) and every book I opened was exactly the same...:banghead: :banghead: :banghead:

Took me a helluva while to work out how to get back in :rotlaugh:

(You only make that mistake once though) :devil:

[Paleo]

I have undone all at the event workbook_beforeclose, but thanks anyway.

[johnske]

I have undone all at the event workbook_beforeclose, but thanks anyway.Good to see, but for the benefit of visitors or any others reading this (or the other allied thread) that may have accidentally locked themselves out - the shortcut to the VBE window is Alt + F11

[Paleo]

Well anyway it sets properties back when the workbook is closed, so they just need to do Ctrl + F4.