Allowing Data Entry ONLY???

  • Thread starter Thread starter mthespike
  • Start date Start date
M

mthespike

Hello and thank you in advance for any assistance you may be able t
provide,

I have a spreadsheet in 03, which I want to give others the ability t
enter data into, but keep them from performing any other functions
such as cell formating, row/column insertion and deletion.

Using the protection and lock features seems to keep everything fro
being editable, but I cannot figure out how to do this, while allowin
the data itself to be edited.

Help??
 
From what you provided you should be able to select all the cells you want
them to have access to then go to format cells and under the protection tab
uncheck the 'Locked' box.

Then once you protect the sheet the should only be allowed to do data entry.
 

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

allow insert rows = false for only some of the worksheet 1
Insert row with a locked cell 1
How do I allow data entry to one column only? 2
Macro to only allow pasting of values and not format?? 23
How do you lock a cell with data but still allow new data entry? 1
How to Lock sort on a data entry sheet. 1
Protecting only Hidden Rows on a Spreadsheet 1
copy cells from multiple pages to one sheet w/ if statement 8

Back
Top