Automate unprotecting of blank cells

J

Jim Palmer

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

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

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

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

Any suggestions would be appreciated.

Jim Palme
 
D

Dave Peterson

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

Jim Palmer

Thanks Dave

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

Thanks for your help.

Jim

My new glasses arrive at the end of the week
 
D

Dave Peterson

LensCrafters--glasses in an hour!

<vbg>

Jim said:
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.
Click to expand...
 
Top