I have a simple file with VBA to import text data into excel, the code
enaabling the useer to select the the name of the text file. Depending on
the text file name the user can name the excel file anything they want. This
worked ok until I tried to protect the vba sheets. Once I did that the code
still worked but the excel file could not be saved. Any idea of why
protecting a project would prevent it from being saved under another name.


ads