Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
Protecting Formulas | Excel Discussion (Misc queries) | |||
PROTECTING FORMULAS | Excel Discussion (Misc queries) | |||
Protecting Formulas | Excel Discussion (Misc queries) | |||
Protecting Formulas | Excel Programming |