I have created a shared (protected) Excel 2010 file that has a couple of macros that work fine for me in the location/directory the file is saved to, presumably because I am the file author. Sadly the macros do not seem to run for anyone else.
The location/directory is in a web access folder, I probably need Sharepoint but is there another solution?
Bookmarks