Excel File: https://www.teachexcel.com/excel-tutorial/2213/use-macros-on-password-protected-worksheets-in-excel?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt

How to make macros that will work on password protected worksheets in Excel - this includes a step-by-step guide to modifying your macros to work on these protected worksheets as well as a few additional steps that will help you build more robust macros for this scenario.

In addition to working on protected worksheets, you will learn how to use VBA / Macros to check if a worksheet is protected and also to enable a macro to work on a worksheet while keeping it password protected for the user.

After viewing this tutorial, you should have no trouble working on protected worksheets.

Enjoy!

TeachExcel.com