Switch to the previous pane in a worksheet that has been split. Switch to the next workbook window when more than one workbook window is open. Switch to the next pane in a worksheet that has been split. Switch between the Help task pane and the application window. Restore the window size of the open workbook.
But movement is left and then to the above row. Selection toggles only until the cell that contains data then goes to the next row. Gives option to save or discard current changes. Repeat last action (for example, create a text box) or toggle among cell references. Set TS = FSO.OpenTextFile(FN, ForReading, Format:=TristateFalse)ĭebug.Print VBComp.Name, M.SubMatches(0), M.Must Read: If you wish to explore basic and general uses of function keys read out post on the best and default uses of function keys F1 Shortcut KeyĬreate a chart from data in the current range.Ĭreate names by using row and column labels. 'Microsoft VBScript Regular Expressions 5.5ĭim sProcName As String, sShortCutKey As Stringĭim RE As RegExp, MC As MatchCollection, M As Match 'Microsoft Visual Basic for Applications Extensibility 'MUST set to Trust Access to the VBA Project Object Model It will NOT list shortcut keys that were assigned using the Application.OnKey method. If a macro does not have a shortcut key, it will not be listed.ĮDIT The routine only lists those shortcuts that were assigned using the Macro Dialog box on the Excel worksheet. (That could have been done in the macro, but I got lazy). If C:\Temp does not exist, you will have to create it. The exported file is stored in a folder C:\Temp, and the file is deleted when we are done with it. I have just output the results to the Immediate window, but you could do also easily put it on a worksheet.
Running the macro below requires that you set the option to Trust access to the VBA Project object model in the Trust Center settings and also that you set references in VBA as listed in the code. I don't know the significance of the \n14 at the end (and I am not sure if it will be consistent as I have not extensively tested this. The bolded information above is the name of a macro, and the associated shortcut key. The line in the exported file that has this information looks like:Īttribute MacroShortCutKeys.VB_ProcData.VB_Invoke_Func = " a\n14"
That file can then be parsed to return the procedure name and the associated shortcut key. It turns out although the shortcut key cannot be accessed "directly", if you export a module, any shortcut key is listed in the exported file. You can list the keys assigned to a macro with a VBA macro.
0 kommentar(er)
