Protecting an Excel spreadsheet

J

jasonamyl

I have an Excel spreadsheet where I would like to allow users to input
data into any cell, however, I want to password protect the entire
spreadsheet so they cannot delete the data once it is inputted into
the cell without being prompted for a password.

Any Suggestions, Thanks- A
 
J

Jim Thomlinson

What you are asking for will require macros. Protection does not work the way
you have indicated... Are you open to using macros???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting data 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Protecting cell formulas in excel 2007 1
Protecting sheets with drop down boxes 6
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Excel Access - importing an excel spreadsheet 0
Protect selected cells without protecting worksheet 2
Reading Only Numeric Value of Cell 4

Top