Macro cannot be found in Read only modus
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
|