ta good idea
"Nick Hodge" wrote in message
...
Teepee
How about the UserForm_Deactivate() event?
Private Sub UserForm_Deactivate()
ActiveSheet.Protect
End Sub
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog:
www.nickhodge.co.uk/blog/
FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
"teepee" wrote in message
...
"Nick Hodge" wrote
I would say, from my testing yes. To be honest, I've always done that
unprotect, change, protect as these were not available pre XP.
Thanks Nick. I think I can workaround. I put ActiveSheet.Unprotect at the
top of the userform that controls the VBA. I just need to find a way to
put
ActiveSheet.Protect in automatically when the userform exits. If you have
any ideas....
Thanks for your advise
TP