Have your macro unprotect the worksheet, do the import, and reprotect the
workbook.



dtg_denver wrote:

I created a macro to import a csv data file. The macro works fine when the
worksheet in unprotected. When I protect the worksheet and click on the macro
button I get a run time erro 1004. I have tried protecting the worksheet with
all the options checked off, but I still get the error. Any idea would be
helpful.

--

Dave Peterson