I have another question, it has to do with the exporting to excel. Now the
code that you modify actually acts like a module for another excel sheet
(template sheet) where I import data from access. Now on this template sheet,
there is an upload button, which will call for the code (the one you helped
out with) and export all teh data and soo on

Now on this template sheet, there is a drop down where the user will pick 5
things
I need to have it that once the user press upload, that comment field will
lock so that they can not change it. Reason is that this 1 sheet is on a
share drive and 3 other people will work it. Now i wish that they can work it
in a day but sometimes 1 person will work 1 day and anotehr another and the
last a week later. The director wants to upload it even if all the work isn't
complete, upload whatever is done, and when the others are completed, upload
that data. I already know that it will upload 2wice, that is where the access
database will determine if this is a duplicate or not, if it is, then delete,
if not, save.
I don't want to 1 user to change that comment field a day later when i
upload it again. That is why i need to know a way to look a field where it
has a comment(there is 5 comments) and lock it once the user press upload.
thanks