Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign ShortCut-key To Toggle VBA-toolbar?
Hi There,
Is it possible to toggle a Toolbar via a shortcut combination? Like: Ctrl + Shift + 0 pops up the VBA-toolbar (or a custom ...) Sige |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign ShortCut-key To Toggle VBA-toolbar?
Look at Application.Onkey
just assign a macro to the key combination that does what you want. -- Regards, Tom Ogilvy "SIGE" wrote in message om... Hi There, Is it possible to toggle a Toolbar via a shortcut combination? Like: Ctrl + Shift + 0 pops up the VBA-toolbar (or a custom ...) Sige |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign ShortCut-key To Toggle VBA-toolbar?
Hi Tom,
I thought there was a way to do it directly but ... I got out of the woods with this: Sub LaunchVBAToolbar() Application.CommandBars("Visual Basic").Visible = True End Sub Sub ShortCutToVBAToolBar() Application.OnKey "^+{v}", "LaunchVBAToolbar" 'ctrl + shift + v End Sub Sub ResetShortCutVBAToolbar() ' To revert to default keypress result Application.OnKey "+^{v}", "" End Sub Thanks, Sige "NOSPAM" to be removed for direct mailing... *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign ShortCut-key To Toggle VBA-toolbar?
' To revert to default keypress result
Application.OnKey "+^{v}", "" This does not revert to the default keypress result. Instead, it makes the keypress action do nothing at all. To revert to the default, omit the second argument to OnKey. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SIGE" wrote in message ... Hi Tom, I thought there was a way to do it directly but ... I got out of the woods with this: Sub LaunchVBAToolbar() Application.CommandBars("Visual Basic").Visible = True End Sub Sub ShortCutToVBAToolBar() Application.OnKey "^+{v}", "LaunchVBAToolbar" 'ctrl + shift + v End Sub Sub ResetShortCutVBAToolbar() ' To revert to default keypress result Application.OnKey "+^{v}", "" End Sub Thanks, Sige "NOSPAM" to be removed for direct mailing... *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign ShortCut-key To Toggle VBA-toolbar?
Ooops...
Though Standard-wise Excel has nothing set on the shortcut: Ctrl+Shift+v So "normally..." it would not make much difference! -I think...- Check: http://www.cpearson.com/excel/KeyboardShortcuts.htm Thanks a lot Chip! Sige "NOSPAM" to be removed for direct mailing... *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut to toggle $ on and off | Excel Discussion (Misc queries) | |||
Keyboard shortcut to toggle between worksheets | Excel Discussion (Misc queries) | |||
Shortcut toggle between worksheets in the same workbook? | Excel Worksheet Functions | |||
Shortcut to toggle active Worksheet | Excel Programming | |||
Toggle ShortCut Key sequence | Excel Programming |