Hi Bob,

Thanks for your help...... ; )
The problem solved now!!

But what is that Use AutoFilter option actually use for in protection???
Why even we selected the option the AutoFilter won't work also???




"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.