Protection Problems when Macros are involved

[DragonSoft]

I have a work book with 6 work sheets, I use macros the change the headers of columns depending on the type of data being entered. Problem is my boss wants the worksheet protected so the people using the spreadsheet do not mess up the headers by typing in them "by accident". When I lock all the cells that no one are to type in I get the debug error when changing the data type (I know it is the macro because if I hit the debug button it goes to the line that changes the header) If I unlock that cell the error skips by that line of code but stops on the next line that try's to change the locked cell. So the question is "How do I lock cells that the data in them is pragmatically produced"?

 

[starl]

Via code, you can protect a sheet using UserInterFaceOnly:=true

this allows code to make changes to protected cells.

Add a workbook_open event that loops through the sheets, protecting them with that additional argument.
This means users CANNOT manually protect sheets.