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

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

how do u lock row? and how do u export data to word document?



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


--
hennessey
------------------------------------------------------------------------
hennessey's Profile: http://www.excelforum.com/member.php...o&userid=31938
View this thread: http://www.excelforum.com/showthread...hreadid=516612

I am applying protection to column K and intend to perform an import that
will bring data into columns A thru H. Other people will be doing the import
from a text file that they are creating (using a macro is not practical) and
I don't want them to mess up my formulas.
Anyway, I select all cells and in format & uncheck the locked box. Then I
select column K and in format check the lock box.
It works fine if I am manually entering data: A-H is unlocked and K is
locked.
It seems like enabling protection on a sheet disables the import function
(it is greyed out). My question is: Is there any way around this?
thx

"hennessey" wrote:


how do u lock row? and how do u export data to word document?



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


--
hennessey
------------------------------------------------------------------------
hennessey's Profile: http://www.excelforum.com/member.php...o&userid=31938
View this thread: http://www.excelforum.com/showthread...hreadid=516612