How to Protect Shee but Allow Autofit to Work

Hi folks,

I'm new to this forum, and also to creating macros.

I would greatly appreciate it if I could call on your expertise, please!!!

I'm attempting to create a workbook whereby individual users have their own sheets with a table, which they can edit freely. The first column of each user's table is supposed to autofill into the 'overview' table (capturing what everybody is working on) on the first sheet of the workbook.

My problem: I want to protect the 'overview' table on the first sheet so it cannot be edited, but still allow users to edit their tables on the remaining sheets and for the information they include to autofill to the protected sheet. However, when I attempt to protect the worksheet, it inhibits prevents the autofit code I've created from running.

Does anybody know how I can get around this?

Here is the code that I've used:

Please Login or Register  to view this content.

Thanks everybody

Please Login or Register  to view this content.

or when you protect, allow format rows?