Hi,

I have successfully automated the process of creating physical inventory count sheets and a 'master' roll up worksheet in an Excel Work Book. I just need one more thing... How do I "protect" the work sheets so that the users can enter data in only the actual count column?

I was able to "unlock" those cells but I cannot seem to "protect" the work sheets.

Thanks,

Ken