Q: How Can I Turn Off the Sandbox

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)

Posted on Oct 22, 2016 6:09 AM

I have this question too

Q: How Can I Turn Off the Sandbox

All replies

Helpful answers

by OnTheEdge1,

OnTheEdge1 Oct 22, 2016 6:16 AM in response to Chaplain Doug
Level 1 (97 points)

Mac OS X

Oct 22, 2016 6:16 AM in response to Chaplain Doug

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!
Reply options

Link to this post

by Chaplain Doug,

Chaplain Doug Oct 22, 2016 6:54 AM in response to OnTheEdge1
Level 1 (4 points)

Oct 22, 2016 6:54 AM in response to OnTheEdge1

Unfortunately this procedure is for PCs, not for Macs, and for Access (which Macs do not have) not for Excel.
Reply options

Link to this post

by OnTheEdge1,

OnTheEdge1 Oct 22, 2016 7:23 AM in response to Chaplain Doug
Level 1 (97 points)

Mac OS X

Oct 22, 2016 7:23 AM in response to Chaplain Doug

Unfortunately I took the wrong link out of my bookmarks. This is the correct link: http://www.rondebruin.nl/mac/mac034.htm
Reply options

Link to this post

by Chaplain Doug,

Chaplain Doug Oct 22, 2016 12:41 PM in response to OnTheEdge1
Level 1 (4 points)

Oct 22, 2016 12:41 PM in response to OnTheEdge1

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.
Reply options

Link to this post

Q: How Can I Turn Off the Sandbox

All replies Helpful answers

by OnTheEdge1,

by Chaplain Doug,

by OnTheEdge1,

by Chaplain Doug,

All replies

Helpful answers