Typical format of of Module named:=OneTestĪttribute OneTest.VB_Description = “This is a test macro by IFM”Īttribute OneTest.VB_ProcData.VB_Invoke_Func = “d Viewable when exported out, as Rob has done. It remains hidden within the VBE and is only

Information about entries defined for the VBA Modulw. I beleive Attribute is like a tag in which you can specify additional Yes, it is the “Attribute” that is the key.

You will notice a line that looks like this:Īttribute Macro1.VB_ProcData.VB_Invoke_Func = “wġ4? Posted in Uncategorized Post navigation It turns out that the shortcut key is stored in the Code Module, but it’s hidden from sight.Įxport the Code Module (right-click the Module, click Export File) then open it in Notepad. While coding the changes, I wondered where Excel stores the shortcut key.Ĭould it be that Excel recognises the code comment? More often than not, the macro recorder will give me a good first draft but I’ll have to edit it some more from within the VB editor. You can reassign your shortcut keys from the Macros window:įrom Excel’s menu: Tools, Macro, Macros… (or hit Alt+F8) The process becomes simple: look at the item, is it ok? yes, press ctrl+w, next item, is it ok? yes, press ctrl+w… over and over.

I’ll assign a shortcut key to the macro, such as ctrl+w, then use it on demand. That is, I cant just run the macro from start to finish – I have to give each item a brief glance before the macro runs.Īt the end of the macro, it’s handy to position the selected cell as the start of the next item in the list. It’s usually a list of cells with a handful of exceptions. I often use Excel’s macro recorder to perform repetitive tasks.

Excel shortcut keys 2015