Protect/Unprotect method of worksheet class failed

michelle · May 13th, 2002, 05:07 AM

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

Tom Schreiner · May 13th, 2002, 05:09 AM

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

michelle · May 14th, 2002, 05:14 AM

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 TakeFocus******* = false

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 05:07 AM	#1
michelle New Member Join Date: May 2002 Posts: 4	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

May 13th, 2002, 05:09 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Please post your code Michelle. Are you using a commandbutton to run your macro? Tom

May 14th, 2002, 05:14 AM	#3
michelle New Member Join Date: May 2002 Posts: 4	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 TakeFocus******* = false