Open File which contains macro

[atgaadesh]

Dear friends,
I had used macro in excel sheet and it worked properly when I was used it on same user. While I copy the file to another user or if another user used that file, 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. Macro : "PERSONAL"

[Bryan Hessey]

Dear friends,
I had used macro in excel sheet and it worked properly when I was used it on same user. While I copy the file to another user or if another user used that file, 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. Macro : "PERSONAL"

Hi,

you cannot force a user to set their Excel to Run Macros level of security.

You can set the book to open with a Front sheet that says 'Enable Macros and close then re-open this book', where the Open macro un-hides the worksheets.

hth
---