Problem with protecting workbooks which have lists.

[Hawkmoth1]

Hello

I originally posted this question at the bottom of a previous question, which I subsequently realised probably wasn’t a sensible thing to do, so I have posted the question afresh below. I hope I haven’t broken any forum rules be doing this.

I am developing a recording programme for moths, which I’m pretty near to completing now, but I have hit an issue which I can’t seem to sort out and any help would be appreciated.

The workbook contains four worksheets on which I am using tables to extend data, on two of the worksheets (‘Macro Moths’ and ‘Micro Moths’ worksheets). I want to protect certain areas of these two worksheets so that users don’t amend or delete any data. The data I wish to protect is linked to the ‘Index’ worksheet. However, once I protect the‘ Macro Moths’ and ‘Micro Moths’ worksheets, the tables on the no longer work, i.e. extend; can anyone help me please?

To make things a little easier I have attached the workbook and the following details below are exactly what I wish to achieve:-
1) On the ‘Macro Moths’ worksheet I want to protect columns A, B, C and E, but obviously for the table to extended when new data is added, rows have to be allowed to be inserted. Users will only be allowed to enter data in columns D and F:T.
2) On the ‘Micro Moths’ worksheet I want to protect columns A, B, C and D, but obviously for the table to extended when new data is added, rows have to be allowed to be inserted. Users will only be allowed to enter data in columns E:T.
3) I also want the complete ‘Index’ worksheet protected except for column G where there will be user input of data.
4) The ‘User notes’ worksheet can be totally protected.

To keep this recording programme as simple as possible I don’t wish to use any macros and/or any code. I am using Excel 2003.
Thanks, Hawkmoth1