window shortcut keys

[MtK]

Does anybody know where I can find or if they can tell me any shortcut
keys that change the display of the window. I know that I can use help
and I have done a search but can't find any. Im looking for a shorcut
key that will hide scroll bars and stuff like that. stuff that is
diplayed in the active window. Like alot of the functions you find
under tools=>options=>view tab. things like that that i can turn on
and off, or hide quickly with a shortcut key. Im just looking for
existing keys not something that I have to make myself. thanks for all
the responses.

 

[Frank Kabel]

Hi
don't think there're shotcut keys for that specific settings but you
may have a look at
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

 

[David McRitchie]

Hi .....,

http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Excellent reference <self serving grin>, overcomes the inability to
quickly find a shortcut in HELP, or to show that there isn't a builtin keyboard
shortcut..

You would need a macro for a shortcut to hide/unhide scrollbars
with your own shortcut keys, which does not fit your requirement
of an existing shortcut. But it's not that hard to set up -- at
least not after you've done it once.

You can record a macro while turning scroll bars on/off under
Tools, Options, View, ...scrollbars...

Do a make over on the macro,

Sub Scrollbar_toggle()
With ActiveWindow
If .DisplayHorizontalScrollBar = True Then
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
Else
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
End If
End With
End Sub

Instructions to install the macro above
Install Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/install.htm

You can then run your macro
with your own assigned shortcut keys,
Creating your own shortcut keys (#mykeys)
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#mykeys

or from Tools, Macro, Macros... (Alt+F8),
or from a toolbar icon, or from a toolbar menu.
Toolbars, Custom Buttons and Menus
http://www.mvps.org/dmcritchie/excel/toolbars.htm