Discussion Locked

Worksheet Protection

0 helpful

3 replies

by heavy civil Aug 2, 2002 last reply Sep 2, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Sometimes I have to unprotect a worksheet and when I leave to go to another worksheet, I forget to enable the protection.

What I would like to do, is write a macro that would enable the protection on this worksheet once I leave it and go on to another worksheet.

Any ideas?

Thanks

3 replies

Right click the tab and choose View Code.
On every sheet enter a macro like:

Private Sub Worksheet_Deactivate()
ActiveSheet.Protect
End Sub

See:

Poster rated this answer

This question was closed by the author

This discussion is closed to new replies.