Automate unprotecting of blank cells
 

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

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

Thanks Dave

I was looking for "blanks" on the go to special screen, however I
didn't notice it.

Thanks for your help.

Jim

My new glasses arrive at the end of the week.


--
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

LensCrafters--glasses in an hour!

<vbg

Jim Palmer wrote:

Thanks Dave

I was looking for "blanks" on the go to special screen, however I
didn't notice it.

Thanks for your help.

Jim

My new glasses arrive at the end of the week.

--
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