Excel 2010 macro does not work when opening in a network location

thao-nhi
thao-nhi used Ask the Experts™
on
I have an embedded macro in an Excel 2010 file. It will pop up a dialog message when the file is opened. It works fine locally on my computer. When I copied the file onto a public folder at work for others to use, nothing fired up. What is missing in the picture? Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
Have the other users enabled macros>

Is their Macro Security level set High which would stop macros running?

Author

Commented:
macro settings
the macro settings are as shown but it does not help. Please advise
Roy CoxGroup Finance Manager

Commented:
You should never have security settings set to Low, that leaves you vulnerable yo possibly malicious code.

Can you attach the workbook.

Author

Commented:
Here is the sample file
Book1.xlsm
Group Finance Manager
Commented:
Your code is WorkBook event code and should be in the WorkBook module, not a Standard module. It will not work on any computer as it is in your example. See the amended workbook attached

Where to paste code
Book1.xlsm

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial