How protect several sheets from modification in Excel 2010

Posted on 2011-10-17
Last Modified: 2012-05-12

there was an option in Excel 2003/Word 2003 to protect the file from modification with a password. On excel 2010, this options seems to be replaced by protect this sheet with password. The problem is, when we do have 50 sheets, I can't go through 50 and put that security on. Is it any way to set it up quickly? I mean by that removing and putting it back quicky? even through a macro?

Question by:David_Pazos
    LVL 50

    Accepted Solution


    In Excel 2010 you can click File > Save As > Tools button > General Options > Password to modify

    With this password you can protect the whole workbook from being changed unless the user supplies the password. It is still possible to use the "Save As" command to create a copy of the workbook, though.

    cheers, teylyn

    Author Closing Comment

    that's it!!! many thanks!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now