protecting formulas

[Reniek]

I would like to block somehow a part of cells in a sheet. For example, there
is a formula inside and I do not want anybody to delete it. Do you know some
solutions?Thanks

 

[Frank Kabel]

Hi
- select all cells for which you want allow changes
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now goto 'Tools - Protection' and protect your sheet

 

[Reniek]

Thank you very much your advice. However the problem is that if any action
is taken after this, a message is displayed and running macro is stopped. I
am looking for a solution which does not stop a running procedure.
Do you know sth? Many thanks in advance.

 

[Frank Kabel]

Hi
this depeneds on you macro. As workaround unprotect the sheet within
your macro and protect it again at the end

 

[Reniek]

Hi,
Thanks it works!!!

Hi
this depeneds on you macro. As workaround unprotect the sheet within
your macro and protect it again at the end