Hi Bob,

Thanks for you help........ : )
Now my problem has solved!!

Anyway, what actually that Use AutoFilter option is use for in protection??
Why even we selected the option but still can't use the AutoFilter during
the protection???



"Bob Umlas" wrote:

Have the code first unprotect the sheet, do its thing, then reprotect the
sheet.

"Jac" wrote in message
...
Hi,

I've recorded a macro which would help me to filter for desired records in
a
data list using MS Excel 2003. After that, I assigned the macro to a
command
button. But I wish to locked the location of the button on the worksheet,
top
(100), left (50). So I used Protect Sheet option to protect the sheet with
Use AutoFilter option being selected. Unfortunately, once I run the macro
after the sheet is protected; a debug will be generated, "Run-time error
1004"!!!

What would be the cause for the debug???
Anyone could help on this????

Thanking in advance.