Excel: Using Personal Macro Workbook to protect all worksheets (Part 3)

In this video I will demonstrate how we can take the code from our previous 2 videos and place it into our personal macro workbook, such that it fires for all workbooks, and such that we don’t need to include the code into our regular workbooks. https://youtu.be/nn9oUsXU5PQ

Excel: Protect All Sheets Part 2

Today we will focus on three simple additions to our code from last time Only run code for a specific user (myself) Prompt the user Add a simple Password to the protection So we start out in VBE, where we add the check by using a call to the Environ function, passing in the variable “UserName”. The Environ function will then return the username of the user currently logged into Windows. If that user is…