Locking & Protecting columns in multiple sheets within workbook

[ave10]

I have a workbook that has many sheets but one sheet called "JE" acts as the main sheet and has a "form" from row 7 to 446 where users populate values in that form. In columns E & G I have formulas in those rows that I want to lock and protect so the user can't edit them. When I lock & hide the rows in those columns and protect the sheet "JE" so that can go into affect, I can no longer double-click values in separate sheets in order to populate the rows in my main sheet. When I try to double-click values in different sheets to populate my main sheet, I get a run-time error '1004' telling me I am trying to change a protected sheet, etc.

Does anyone know of a way that I can protect those columns and still be able to double-click values in order to populate my main sheet?

I can provide more details and elaborate more on the issue, if needed. Thanks in advance!

 

[Fluff]

Hi
In your double-click procedure you'll need to un-protect the main sheet