I've seen the postings related to protecting cells and worksheets and tried
to implement them on my workbook, but they're not working the way we would
like them to, so I'm posting my question in hopes of getting some ideas. We
have a workbook with a variety of worksheets. It is an expense tracking log
with each worksheet assigned to an individual. The manager then reviews this
workbook monthly. There are 6 columns, with the first 4 as data, the 5th as
the amounts column and has a sum function at the end. The 6th column is
where the manager will approve the row. My questions a

1) is there a way to protect the first 5 columns after the individual goes
to the next row or closes the log? We don't want them to go in and change
their entry before or after the manager reviews the data. As for the 6th
column, it will be locked after the manager signs off the rows. Typos and
errors have been discusses and will be dealt with accordingly.

2) will it be possible for the indivdual to insert rows as needed and will
the protection be carried over to the new rows?

3) is this applied to each worksheet specifically or can it be applied
globally to the entire workbook?

If I can clarify any of my questions, please let me know. Thank you for all
your help!