Unprotection once performed...

F

FLKULCHAR

I have protected certain formulas via the following method:

Select cells
go to "Data/Validation"
choose "Custom"
and write =""

Those cells ARE PROTECTED.

HOW DO I UNDO THE ABOVE?????????

Thank you,

FL Kulchar
 
D

Dave Peterson

Do you mean you want to restore previous data|validation rules?

If you do, I think you'll have to put them back manually (may be quite a pain if
you had lots of rules).

Do you have a backup copy of your workbook?
 
F

FLKULCHAR

I only want to UNPROTECT the cells that my routine protected.

I have figured out this way:

SELECT ALL
Then, go to data, validation, and "clear"

Will this work???
 
D

Dave Peterson

That'll remove all the Data|validation rules for those cells.

And that sounds like what you want.
 
Top