How protect several sheets from modification in Excel 2010

Posted on 2011-10-17
Medium Priority
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

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 36978778

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

ID: 36978863
that's it!!! many thanks!

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
New style of hardware planning for Microsoft Exchange server.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

864 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