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
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?
thao-nhi
ASKER
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.
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.
Is their Macro Security level set High which would stop macros running?