I created a macro where the code has been password protected.
The macro uses the .SaveAs method and the FileFormat argument is set to
xlText.
This combination of the .SaveAs to xlText and the password protecting of the
macro causes it to fail.

Any idea how to get around this. I do not want the users to have access to
the code.