Hi Frank,

Shared workbooks, are subject to numerous limitations; see
'Limitations of shared workbooks'
in Excel Help.

However, as suggested in my previous response:

To enable effective assistance, try posting the problematic
code and indicate the code line that is highlighted in response to
the encountered error.


---
Regards,
Norman


"Frank Situmorang" wrote in message
...
Norman:

This is the error message: VBA is "Run time error "1004"
Advanced Filter Method of Range Class failed".

It works now in my computer when I changed the security from medium to
high
and from the Shared to Unshared.

I do not know, how can I make this worksheet be sharable and macro can
work
for other users. Actually the purpose of the macro is just to show the
selected record and copy it in another sheet from a huge number of
records.

Thanks in advance for your help.

Frank