I'm sharing a spreadsheet on a network so some of the functionality of my VBA code is not available. I'm therefore trying to write some code to do one thing if it's shared, do another if it's stand-alone. Is there any syntax that will return whether a file is shared or not ?