Macro

[Guest]

I had used macro in excel sheet and it worked properly. While I copy the file
to another user at that time it never run the macro. Please suggest me that
how can I transfer the file so that the macro will run properly on any system.

 

[JE McGimpsey]

Does the other user have security set to High so that macros don't run?
In that case there's not much one can do.

Is your macro an event macro that should run automatically? Or does it
need to be triggered from a button, keystroke, or menu choice?

Is the macro actually stored in your workbook, rather than, say, in your
Personal.xls workbook?

 

[Dave Peterson]

Any chance that the other user didn't enable macros?

Tools|Macro|Security|Security level tab

Change to Medium (to be prompted each time you open a workbook with macros)
change to low (to avoid the prompt, MS recommends against this)

And then close your workbook and reopen it.

 

[Guest]

Check the Security level of Excel in the receiving computer