Paste Special to copy Cell Protection status from one sheet/range/cell to another?

[Kelvin Stott]

Hello,

I have a template worksheet in which most cells are marked as "Locked" for protection (under format) while specific cells are left unlocked. Now I want to copy this specific arrangement of locked/unlocked cells (not the cell contents, just the protection status) onto many other sheets. However, the Paste Special menu does not seem to allow this.

Is there a special command in VBA which will allow me to paste just the arrangement of locked/unlocked cells from one sheet to another?

Currently all sheets are unprotected (at least until I figure out how to lock/unlock the right cells as above).

Thanks for any help.

K.