I have encountered problems when running Macros where an error is displayed because the file is Shared and the code will not work with a shared file. i.e. UnMerge
Is there a piece of VBA code that will, when it opens a file, identify the fact that the file is shared and say something like, "the file you are opening is Shared and will cause problems with this Macro. Please save a file that is not shared"