I have created Macro for Advance filter from Master sheet and put the
selected records to the other sheets. When I tested it OK, I put it in the
server, since this is excel I changed it to be sharable and I changed the
macro security level from High to Medium.

When my subbordinate run it, the macro does not work and the error messagae
of VBA is "Run time error "1004"
Advanced Filter Method of Range Class failed"

Any ideas on how to make it run for other users are very much appreciated

Frank

Hi Frank,

'---------------
have created Macro for Advance filter from Master sheet and put the
selected records to the other sheets. When I tested it OK, I put it in the
server, since this is excel I changed it to be sharable and I changed the
macro security level from High to Medium.

When my subbordinate run it, the macro does not work and the error messagae
of VBA is "Run time error "1004"
Advanced Filter Method of Range Class failed"

Any ideas on how to make it run for other users are very much appreciated
'---------------

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
...
I have created Macro for Advance filter from Master sheet and put the
selected records to the other sheets. When I tested it OK, I put it in the
server, since this is excel I changed it to be sharable and I changed the
macro security level from High to Medium.

When my subbordinate run it, the macro does not work and the error
messagae
of VBA is "Run time error "1004"
Advanced Filter Method of Range Class failed"

Any ideas on how to make it run for other users are very much appreciated

Frank

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



"Norman Jones" wrote:

Hi Frank,

'---------------
have created Macro for Advance filter from Master sheet and put the
selected records to the other sheets. When I tested it OK, I put it in the
server, since this is excel I changed it to be sharable and I changed the
macro security level from High to Medium.

When my subbordinate run it, the macro does not work and the error messagae
of VBA is "Run time error "1004"
Advanced Filter Method of Range Class failed"

Any ideas on how to make it run for other users are very much appreciated
'---------------

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
...
I have created Macro for Advance filter from Master sheet and put the
selected records to the other sheets. When I tested it OK, I put it in the
server, since this is excel I changed it to be sharable and I changed the
macro security level from High to Medium.

When my subbordinate run it, the macro does not work and the error
messagae
of VBA is "Run time error "1004"
Advanced Filter Method of Range Class failed"

Any ideas on how to make it run for other users are very much appreciated

Frank

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