Let's check out ways that we can make our macros accessible to the end user. We shouldn't expect the user to go into the VBA backend or even, into the Excel Run Macro menu-option to use our macros. We can make our macros available by:
Adding a Macro to a Form Button
Adding a Macro to the Quick Access Toolbar
Adding a Macro to a Picture, Shape or Icon
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
00:00 Intro
00:57 Form Button
07:09 Quick Access Toolbar
08:41 Picture/Shape/Icon