View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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