Avatar of thao-nhi
 asked on

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

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.
Microsoft Excel

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon
Roy Cox

Have the other users enabled macros>

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

macro settings
the macro settings are as shown but it does not help. Please advise
Roy Cox

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

Can you attach the workbook.
Your help has saved me hundreds of hours of internet surfing.

Here is the sample file
Roy Cox

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question