Record a macro when you select your range
Edit|goto|special|but click blanks
then format|cells|protection tab|uncheck Locked



Jim Palmer wrote:

I have a spreadsheet that has several cells with values entered into
it.

I want others to add some values, but I don't want them to change cells
that already have values.

I know that I can use goto, special, constants and protect those
cells.

Can someone recommend a macro or method to review each cell within a
specified range and unprotect it if it is blank?

Any suggestions would be appreciated.

Jim Palmer

--
Jim Palmer
------------------------------------------------------------------------
Jim Palmer's Profile: http://www.excelforum.com/member.php...fo&userid=5210
View this thread: http://www.excelforum.com/showthread...hreadid=466861

--

Dave Peterson