I have sent 2006 Budget worksheets to all my franchises, who have entered
data already. I've added some features that I want them to use and want to
copy their data into the new worksheet. I also want to create macro that
writes a statement in a protected field. All the sheets are protected with a
password I do not want them to knowm but they do have access to certain cells
to enter their data.
When I send the new worksheet, I want to create a macro that copies their
data and then writes that the import is done.
How can I use the macro to unprotect a sheet, write the statement, protect
the sheet again, and make sure they do not have access to the password?