You are here:
- Home
- Computing/Technology
- Microsoft Software
- Excel
- Password protect cell editing
Excel/Password protect cell editing
Advertisement
Question
Hello Chad!
Please look at this post before trying to answer my question.
http://en.allexperts.com/q/Excel-1059/2008/2/Cell-protection-password.htm
It is about a small library excel file.
I understood what was written in that post but what I would like is that the people coming into the library to see the file but not to be able to edit anything without the password.
Is that possible in any way?
Thank you in advance! :)
Thorsten
Answer
Thorsten,
That is a functionality that is built into Excel. You don't mention which version of Excel you have and the way to access it is slightly different in Excel 2007 compared to previous versions. In Excel 2007 select the review ribbon and then click "Protect Worksheet." In previous versions select the Tools menu and then select Protection>Protect Worksheet. In the box that opens, give or restrict any permissions you would like and enter your password. After clicking OK, you will need to verify the password. Select each worksheet in the workbook and repeat this process. Save the workbook and it will now be locked down to anyone without the password.
Best regards,
Chad Welch
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Chad Welch
Expertise
I have a lot of experience with VBA; Sub procedures, functions etc. I am also very familiar with array formulas.
Experience
I've worked with Excel for several years. I've been answering questions on various groups and lists for a while.
Organizations
Brainbench MVP for MS Excel.
©2009 About.com, a part of The New York Times Company. All rights reserved.