Protection

[sooty86]

I have an extremely inelegant and complicated workbook, attached. It's taken me ages to get to this point and now I have one last stumbling block. As you can see, data is entered into 'input' and copied across into summary, whereby a number of graphs are plotted.

Problem: I want 'summary' and all the charts to be protected so that the users can't accidentally (or otherwise) mess with the data. How can I get round this? I've played with the usual 'userinterface' stuff but can't figure it out.

Any help would be much appreciated!

P

[zbor]

Data -> protect sheet -> choose some password

If you want some cells to be unlocked (that can be changed even if sheet is protected) then first right click on cell(s) -> format cells -> Protection -> Uncheck Locked box

[sooty86]

If you take a look at the workbook, the cells I want to protect are the ones I'd like to copy into - so unfortunately your solution dosen't help in this case!

[royUK]

If you are copying data using code then add protect/unprotect into the code. Ideal way is to use UserInterface only, see example here

http://excel-it.com/vba_examples.htm