Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

To me, it seems like the way to edit a protected sheet is unprotect it and type some stuff in and then protect it again before sending it to someone else. What if a user forgets protecting it before sending it again? Is there a way I can always protect it?

share|improve this question
    
You could add a macro to the Save event that forces the sheet to be protected. That's the only thing I can think of. – user3463 May 23 '12 at 23:25
    
@RandolphWest Macro-approach was what I was thinking too. – TPR May 23 '12 at 23:26
    
My Excel macro knowledge is so rusty, I won't even try to answer this question, but that's the way I'd go about it. – user3463 May 23 '12 at 23:27

You can use the macro recorder to incorporate the elements you want to make sure are protected. @Randolph West is probably right in the approach

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    ActiveWorkbook.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
    ActiveWorkbook.Protect Structure:=True, Windows:=True
End Sub
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .