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
Last Comment
Roy Cox
ASKER
the macro settings are as shown but it does not help. Please advise
You should never have security settings set to Low, that leaves you vulnerable yo possibly malicious code.
Can you attach the workbook.
Can you attach the workbook.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
Here is the sample file
Book1.xlsm
Book1.xlsm
ASKER CERTIFIED SOLUTION
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
or
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
Is their Macro Security level set High which would stop macros running?