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:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
   Dim WS As Worksheet
   For Each WS In ThisWorkbook.Worksheets
     WS.Rows.AutoFit
   Next
 End Sub

Thanks everybody

thisworkbook.unprotect "password"
Dim WS As Worksheet
   For Each WS In ThisWorkbook.Worksheets
     WS.Rows.AutoFit
   Next
thisworkbook.protect "password"

or when you protect, allow format rows?