protecting formulas
 

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

protecting formulas
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Reniek wrote:
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

protecting formulas
 

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.

Uzytkownik "Frank Kabel" napisal w wiadomosci
...
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

--
Regards
Frank Kabel
Frankfurt, Germany


Reniek wrote:
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

protecting formulas
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Reniek wrote:
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.

Uzytkownik "Frank Kabel" napisal w
wiadomosci
...
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

--
Regards
Frank Kabel
Frankfurt, Germany


Reniek wrote:
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

protecting formulas
 

Hi,
Thanks it works!!!

Uzytkownik "Frank Kabel" napisal w wiadomosci
...
Hi
this depeneds on you macro. As workaround unprotect the sheet within
your macro and protect it again at the end

--
Regards
Frank Kabel
Frankfurt, Germany


Reniek wrote:
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.

Uzytkownik "Frank Kabel" napisal w
wiadomosci
...
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

--
Regards
Frank Kabel
Frankfurt, Germany


Reniek wrote:
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