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.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Have the other users enabled macros>
Is their Macro Security level set High which would stop macros running?
Is their Macro Security level set High which would stop macros running?
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 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
Where to paste code
Book1.xlsm
Premium Content
You need an Expert Office subscription to comment.Start Free Trial