• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Show Search
Hide Search
Home » How To » How to Unprotect Multiple Worksheets in One Go Using Excel Macro

How to Unprotect Multiple Worksheets in One Go Using Excel Macro

May 23, 2011

Macros are an effective way to achieve certain tasks that are not possible using common Excel commands. One such task involves protecting and unprotecting multiple Excel sheets instantaneously. Just as Excel allows you to only protect one worksheet at a time, unprotecting multiple worksheets is also a manual process. However, you can make use of macros to automate the task and save yourself a lot of time. In this post, I’ll show you how to unprotect multiple worksheets using a simple excel macro.

  • Tip: If you'd like to learn about how to create macros without writing them from scratch, check out our tutorial on Creating Macros Using the Macro Recorder.

How to Unprotect Multiple Worksheets

To unprotect multiple worksheets in one go using an Excel Macro:

Basic Macro Info

Level of Difficulty

Easy

Works On

Excel 2007, 2010

Description

This macro will allow a user to simultaneously unprotect multiple worksheets in a workbook.

Code:

Unprotect_selected_sheets()
Set wrksheet = ActiveWindow.SelectedSheets
For Each ws In wrksheet
ws.Select
ws.Unprotect Password:="password123"
Next ws
End Sub

Note: You need to use the same password you used to protect your worksheet.

How to Unprotect Multiple Worksheets

1. Copy the code.

2. Open the Excel worksheet that has protected worksheets and Ctrl+click the worksheets that you want to unprotect.

3. Press Alt + F11 to enter the Visual Basic Editor. If necessary, press Ctrl + R to show the Project Explorer.

4. Right-click This Workbook.

5. Choose Insert -> Module.

6. Paste code into the right pane.

7. Save the workbook in the XLSM format.

8. Press Alt + Q to close the VBE.

ALSO READ:  How to Use Excel Functions in Formulas

9. Select the Developer tab. (If the Developer tab is not displayed, please read our post How to Activate the Developer Tab in Excel 2010.

10. On the Developer tab, in the Code group, click Macros.

11. In the Macro dialog box, select the macro and click Run.

Make use of this simple macro to unprotect selected worksheets in one go.

Tweet
Share1
WhatsApp
Pin
Buffer
1 Shares

Filed Under: How To Tagged With: excel how to, excel macros

You May Also Like

Ways to Use Excel Mobile - TATFI
10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Amazon Fire Max 11 - TATFI

Amazon Launches the Amazon Fire Max 11 – Its Biggest and Most Powerful Tablet Yet

Google Pixel Tablet - TATFI

Google Pixel Tablet: An Exciting New Tablet for Android

Google Pixel 7 vs Google Pixel 7a - TATFI

Comparing the Google Pixel 7a and Pixel 7: Which to Buy?

Top Gaming Mouse Brands in 2023 - TATFI

Top Gaming Mouse Brands to Maximize Your Gaming Experience in 2023

HyperX Pulsefire Haste 2 - TATFI

Pulsefire Haste 2 – A Great Wireless Gaming Mouse from HyperX

5 Great Portable Power Stations - TATFI

5 Great Portable Power Stations for Indoor and Outdoor Use

Garmin Instinct 2X Solar - TATFI

Garmin Instinct 2X Solar Launches with Flashlight and More Great Features

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook gadgets gaming gmail google ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets technology twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
How to Control Your Apple Watch Using Hand Gestures

How to Use AssistiveTouch Gestures to Control Your Apple Watch

Fairplay Club Betting App - TATFI

Fairplay Club Is the Best Mobile Betting App in India

Parimatch India App - TATFI

Parimatch India App: Experience Unmatched Benefits, Odds, and Support

1Win Betting App - TATFI

Enjoy the Best Betting App in India With 1Win

Sony HT-S2000 Soundbar - TATFI

Sony Launches the Incredible HT-S2000 3.1ch Dolby Atmos Soundbar

Backpack for iMac and Studio Display - TATFI

Declutter Your Desk with the Ultimate iMac and Studio Display Storage Solution – BackPack

Latest technological innovations - TATFI

Latest Technological Innovations to be aware of as a Businessperson

5 New Video Games to Play in May 2023 - TATFI

5 New Video Games to Play in May 2023

Apps That Users Could Make Money From - TATFI

Apps That Users Could Make Money From

IT Security - TATFI

How Important IT Security Can Be for Small Businesses

How To Make Extra Cash Using Apps And Gadgets - TATFI

How To Make Extra Cash Using Apps And Gadgets

Audio Editing Tool Audacity - TATFI

5 Good Reasons to Use Audio Editing Tool Audacity

TheAppTimes © 2023 // Runs on StudioPress