delete only cell values (not formulas) in multiple sheets

**alexandruc** · 11-03-2009, 02:49 AM

Hello,

I am trying to make a button that will re-initialize the workbook: clear (delete) all unlocked cell's values.

I have the following code:

Please Login or Register  to view this content.

This works fine with the cells that are protected, but the problem is that I use formulas on a sheet that has cells which are not protected.

How can the above code be modified so that will not clear (detele) the formulas, but only the values in cells.

Thank you

**royUK** · 11-03-2009, 03:42 AM

Protect the formula cells

**alexandruc** · 11-03-2009, 03:47 AM

Originally Posted by royUK

Protect the formula cells

Yes, I know that could be a solution, but I would like to give the users the posibility to manually alter those cells.

If it's not something that can be done easyly I will eventaully protect the cells.

Thanks

**royUK** · 11-03-2009, 03:52 AM

Why would you want to allow users to alter formulas?

**alexandruc** · 11-03-2009, 04:25 AM

Originally Posted by royUK

Why would you want to allow users to alter formulas?

The formula brings from another sheet some comments (if they are any).

I want to give them the option to change those comments on this sheet.

But now that I think it through (thanks to you), it's not ok, because it will remove the formula and the reinitialization of the workbook will not put the formula back in the cell if the user altered his comment.

In other words I will protect those cells

Thanks for the help!

p.s: it would still be nice to know how to clear cell content without deleteing formula via VB.