𝗪𝗜𝗟𝗗𝗘𝗦𝗧 𝗗𝗜𝗦𝗖𝗢𝗨𝗡𝗧 𝗢𝗙 𝗧𝗛𝗘 𝗬𝗘𝗔𝗥 - 𝟲𝟱% 𝗦𝗔𝗩𝗜𝗡𝗚𝗦 𝗙𝗢𝗥 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬 https://www.excelforfreelancers.com/BFSale2024_YTDesc


In this video, I'm going to show you how to use some of the powerful features of Microsoft Excel VBA to automate tasks and protect your data. We'll start by learning how to set up macro security, and then we'll move on to the more complex topic of automated sorting. By the end of this video, you'll be able to use VBA to tackle almost any task in Excel, safely and effectively!


𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:
http://bit.ly/VBASorting_WkbkDl


Timestamps:
0:00 – Introduction
1:29 – Overview
2:36 – Macro Security
4:07 – VBA Editor Options
5:22 – Test Macro
12:21 – Sort Names
22:57 – Insert Shape
25:07 – Selection Change Event
25:43 – Change Event Worksheet


#vba #excelvba #Vbaforbeginners #Excelforfreelancers #ExcelSorting #sorting