Trouble Protecting Cells in a Macro

[KClark]

Hi All,

I have developed a spreadsheet where the individual clicks on a button to add the next week for cost tracking. The macro copies an already formatted week from another sheet in the workbook and adds it to the sheet where the actual cost tracking is taking place. My problem is that I can't figure out how to have the already formatted week drop in to the active sheet with the cells locked that I need to have locked.

FYI, I don't know anything about VB coding so I may be a difficult student!

[TMS]

Please post your sample workbook ... otherwise there's not much to go on.


Regards

[KClark]

Sorry! Here is the workbook. The red tabs are the formatted weeks that go into the active sheets for weekly tracking.