Protect/Unprotect method of worksheet class failed

[michelle]

I have a problem when using Protect or Unprotect method to a worksheet. I got a message "Run-time error 1004"
Anybody can help me ...
I've wrote the macro a while a go (3 months)
before it works fine... somehow now I can not protect or unprotect my sheet from macro

thanks in advance

michelle

 

[Legacy 98055]

Please post your code Michelle.
Are you using a commandbutton to run your macro?
Tom

 

[michelle]

Yes, I'm using commandbutton to execute macro
but anyway... It is working right now.
I found out that I have to set commandbutton property TakeFocusOnCLick = false