Maybe you could record a macro that unprotects the sheet, imports the data, and
reprotects the sheet.

Or you could import to a different worksheet and copy|paste to its real home?

Robert wrote:

I have my sheet protected with only one column locked. This works fine but I
also want to be able to import data with protection enabled. When protection
is enabled, the import data commands are greyed out. The data that I will be
importing will not attempt to overwrite the column that is locked.
Is it possible to lock part of the sheet and import data?

thanks in advance,
Robert

--

Dave Peterson