The code opens a dialog box which enables the user to select the text file
to import, all text files being of same layout. After selection the data is
imported into the excel file. The problem is the code works if the project
is protected or not with any named text file, its is that the file cannot be
saved under a different name if the project is protected, if it is not
protected the excel file can be saved under any name the user chooses.

ads

"Avner " wrote in message
...
i'm not sure,
The name of the Text File is entered into your code. you are the only
one that can save changes to the code (while saving the file).
Maybe try reset variables before closing.

Or maybe i am wrong

Avner


---
Message posted from http://www.ExcelForum.com/