sheet protection

[TKF]

I have an excel workbook that has certain cells in sheet one protected.
My users have found that if they copy sheet 1 to sheet two, they get
all of the data, but the protection is no longer there. They then
change things they shoudn't and it throws off the entire process.

is there any way i can keep the protection when they copy to a new
sheet or even when they insert a new sheet then copy to that one.

I have written a macro that fires every time a new sheet is activeted,
but I can't seem to get that to work either.

Thanks

 

[Dave Peterson]

If your worksheet has formulas, maybe you can foil the users by locking the
formula cells and then hiding them.

Format|cells|Protection Tab|Locked and Hidden.

Now when those formula cells are copied|pasted, the formulas get pasted as
values.

That said, worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.