Pass protection from a master to a slave workbook

I have a master workbook with which I can produce slaves from but I am looking at keeping certain cells protected to stop deletion (dates etc). What I require is for the top 5 rows to be protected on each of the 4 week sheets where the dates etc are. I had played with protecting all the sheets and with unprotect then protect on the master but it did not carry over to the newly created slave, could someone point me in the right direction please.

SOLVED: The code is not pretty but functional.

Please Login or Register  to view this content.

Why don't you protect the cells in the original workbook/ The new workbook will have those cells protected

Originally Posted by royUK

Why don't you protect the cells in the original workbook/ The new workbook will have those cells protected

I do have them protected but a macro has to enter dates into protected cells and being protected it stops the macro. What I was looking for was for code to unprotect the sheets, let the macro run then reprotect the sheets and for that protection to carry over onto the slave. Thank you for your reply.

Just to add, I have managed to keep the master protected after macros but the protection is not carried over to the slave if that helps.

SOLVED. I managed to solve it by asking it to protect prior to save of slave and to reprotect after rehiding of sheets