One person opens the file in write mode. Another person opens the same file
in Read Only mode. At that time the Read Only user get the message: Macro
cannot be found (after activating a macro).

How can I solve this ?

Thanks in advance,
Coen Burger

How is the macro run?

Is it a button on the worksheet? Is it a button on a toolbar?

In either case, it sounds like the thing that's clicked doesn't have the correct
macro assigned to it.

If it's a button (from the Forms toolbar) on a worksheet, try rightclicking on
it and choose Assign macro. You'll see where it's pointed.

If it's a button on a toolbar, you can:
Tools|Customize (just to see that dialog)
Then rightclick on the button and check the macro assignment.

If this doesn't help, you should post more info.

Coen Burger wrote:

One person opens the file in write mode. Another person opens the same file
in Read Only mode. At that time the Read Only user get the message: Macro
cannot be found (after activating a macro).

How can I solve this ?

Thanks in advance,
Coen Burger

--

Dave Peterson

The macro is run bij a button. This file is placed in a network environment.
The macro worked for months in a two user (1 write and 1 or more read only
users). Every month the file is renamed every month. Assigning the macro to
the button again did not solve the problem.
The macro button is placed in every sheets and perfoms actions in relation
to the active sheet. Therefore there is only one macro for all 32 sheets.

With kind regards,
Coen Burger

"Dave Peterson" wrote:

How is the macro run?

Is it a button on the worksheet? Is it a button on a toolbar?

In either case, it sounds like the thing that's clicked doesn't have the correct
macro assigned to it.

If it's a button (from the Forms toolbar) on a worksheet, try rightclicking on
it and choose Assign macro. You'll see where it's pointed.

If it's a button on a toolbar, you can:
Tools|Customize (just to see that dialog)
Then rightclick on the button and check the macro assignment.

If this doesn't help, you should post more info.

Coen Burger wrote:

One person opens the file in write mode. Another person opens the same file
in Read Only mode. At that time the Read Only user get the message: Macro
cannot be found (after activating a macro).

How can I solve this ?

Thanks in advance,
Coen Burger

--

Dave Peterson