Create a Macro

A collection of 7 posts

How To Protect Macro VBA Code In Excel

Just like you can password protect workbooks and worksheets, you can password protect a macro in Excel from being viewed (and executed). Place a command button on your worksheet and add the following
18 October 2020

How To Quickly Swap Values In Excel

This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs as we will see later. Situation: Two values on your worksheet.
16 October 2020