Cell Protection on a Excel Sheet with Hidden Cells

[gailb14]

I created an excel worksheet in which certain cells are used for input of data. Those input cells are duplicated depending on a number in one of the cells.
Example: a sequence of numbers is required on a label. if the label is run two wide, when 2 is entered, additional cells for the second sequence of numbers appear.

When I try to protect certain cells on the worksheet and I set the protection, the duplication of the cells through the VBA program no longer works.

If my explanation is not clear, just let me know.

Thanks
Gail

[Leith Ross]

Hello Gail,

You will need to modify your VBA code to unprotect the worksheet before copying the cells and reprotect the sheet when you are done.

Please Login or Register  to view this content.

Sincerely,
Leith Ross