Archive
Archive for July, 2016
Have your VBA Add-in autogenerate menus for easier access to your macros
2016/07/22
Leave a comment
- Storing your macros in add-ins (.xlam) has many advantages over personal.xlsm and similar document locations.
- One disadvantage however is that an Add-in macro is not accessible through the Excel macros dialogue.
- The community recommends assigning shortcuts for easy access. I did that and went a couple of steps further using VBE extensibility to
- depending on scope
- public procedures on your end users’ computer to whom you distribute your Add-in
- and also non-private on the developer machine
- list your modules alphabetically
- list your macros alphabetically under your modules
- for each, find & assign a free (free within Excel only – short of assigned windows-wide shortcuts since in my current work environment, I am unable run tools that allow you to list these shortcuts) shortcut combination,
- automatically generate an Add-Ins menu of all that , to serve as a cheat sheet.
- depending on scope
- Code TBA
Categories: service-is-documenting, service-is-programming, sourcecode
add-ins, MS-Excel, ribbon, VBA
Questions? Read the About. Or just ask me a quick
FAQs for LRC student staff or for students or for teachers. To search our FAQs, in the browser addressbar, add after "https://plagwitz.wordpress.com/feed/?tag=faqs+/" "+TAG1" (from tag cloud below) OR "https://plagwitz.wordpress.com/feed/tag=faqs
&category_name=" "CAT1" (from category hierarchy below). OR search both categories and tags, and multiple TAGs/CATs (connect with "," for OR-search, with "+" for AND-search), like so: https://plagwitz.wordpress.com/feed/?tag=TAG1+TAG2+...TAGn&category_name=CAT1
+CAT2+...CATn"
Other ways to find help
If you cannot find it here, look there: 5,500 Language-Learning Links and Programs for learning or teaching 150 languages
Shortcuts:Our Lists, Our Maps, LRC Staff Moodle Site,LRC Project Moodle Site, 49erexpress, UNCC Moodle, Student Recordings: s:claslcslrcsanakostudent
Learning usage samples: Sanako oral exam, Kaltura webcam presentation, Dictation with speech recognition, Sanako written exam, Chinese and Japanese interactive stroke-order practice
Test the Sanako Installer, Webbrowser Popup Konfigurator for XP, or Windows7, faster LRC TeacherPC Log-in Let MS facilitate diacritics writing by installing for you US-International keyboard layout
This is my personal blog (Google+). The views expressed on these pages are mine alone and not those of my employer. The information in this weblog is provided “AS IS” with no warranties, and confers no rights.
Thomas' Work Space 