Concatenate Range: Security Settings (Office XP/2000-2003)

Follow these steps to allow Concatenate Range to operate properly:

Before installing Concatenate Range, ensure the ConcatenateRange.zip file is not being blocked by Windows: right-click the ConcatenateRange.zip file, select Properties. If you see an Unblock button, click the Unblock button, then click OK:
After installation, open Microsoft Excel, select the Tools menu, select Macro, Security…:
image004
It is recommended that Security Level be set to Medium:
image006
Close and re-open Excel. If prompted to enable macros for ConcatenateRange.dll, click Enable Macros:

If you are still experiencing issues, you may need to uninstall then re-install Concatenate Range, or contact us for support.

That’s it!