View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Macro runs OK for me, but not for the other users

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