[This is the first tutorial emailed in 2017 to members of my Excel Heaven Visual Basic Automation Tutorial]

Sometimes you have a multi-worksheet workbook in which you’d like to apply blanket password protection to every sheet, without having to do so manually.

The two macros in this workbook enable the user apply and remove password protection to each sheet manually.

The user is prompted to enter the password when each macro runs.

What I’ve done is to place 2 form control command buttons on the “Staff” worksheet – with each labelled with descriptive text indicating its function (see screenshot below).

In the screenshot video tutorial accompanying this message and the MS Excel multi-worksheet working I explain the various lines of code in the first macro. A second video will follow.