I am having trouble with the Sandbox and accessing files from Excel 2016 from VBA code behind. Does anyone know how to turn off the Sandbox for Excel 2016 or how to turn it off completely? Thanks for any help.
MacBook Pro, OS X El Capitan (10.11.6)
Hi,
It's not complicated to disable it. You can find a complete and easy manual here: https://support.office.com/en-us/article/Turn-sandbox-mode-on-or-off-to-disable- macros-8cc7bad8-38c2-4a7a-a604-43e9a7bbc4fb
Good Luck!
Thanks On The Edge. Unfortunately Ron's workaround makes you create a local folder into which everything you are working on in Excel must reside. That is too limiting for my application. My Excel code opens files on a network share.
Unfortunately this procedure is for PCs, not for Macs, and for Access (which Macs do not have) not for Excel.
Unfortunately I took the wrong link out of my bookmarks. This is the correct link: http://www.rondebruin.nl/mac/mac034.htm
How Can I Turn Off the Sandbox
