[Excel Heaven Tutorial 07] Macro Protect or Unprotect Worksheets in a Workbook

[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.

[IMPORTANT: This blog’s contents are being updated following the transfer to www.tayosolagbade.com from my former domain – Spontaneousdevelopment.com. As a result, some parts of it may not work properly for now. Quick Tip: If a link contains “spontaneousdevelopment.com”, simply change it to “tayosolagbade.com” – and it should work. This applies to article links as well as image links. Work continues to update the links(in over 500 articles). Tayo K. Solagbade.]
Practical Livestock Feed Formulation Handbook Available as a PDF ebook, and also as a spiral bound print manual (from me). Click here for details. You can also get it as an PDF ebook via my online store. $82.5 USD to buy it from my online store (PDF download) N8,000.00 [Eight Thousand Naira] for persons who wish to send payment direct to my bank account. Payment of N50,000.00 gets you the physical handbook and software on CD with videos etc, PLUS practical one-on-one, in person training with me at a feed mill in Lagos, Nigeria. Click here to contact me about purchasing this product. Your Gifts for Subscribing When you signup, you’ll receive: Once you submit the form below, you will be taken directly to the downloads page, just as an auto-response message will be delivered to your inbox, with links to the promised gifts. I look forward to meeting and/or working with you! Tayo K. Solagbade* Performance Improvement Specialist & Multipreneur Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club & Competition(www.excelheaven.biz) Excel-VB Driven Ration Formulator 1. Click here to learn more about this app – watch demo videos etc 2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student. Click here to contact me about purchasing this product. EXCEL-VB DRIVEN* POULTRY LAYER FARM MANAGER SOFTWARE Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs. Click here to contact me about purchasing this product.
Name:
Email:


Powered by Optin Form Adder