Thread: Excel 2007 VBA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
teepee teepee is offline
external usenet poster
  
Posts: 103
Default Excel 2007 VBA

"Nick Hodge" wrote

How about the UserForm_Deactivate() event?

Private Sub UserForm_Deactivate()
ActiveSheet.Protect
End Sub

And my final dumb question - why does this subcommand not work. Presumably
it goes inside the userform?



Reply With QuoteReply With Quote