Protection? or backend coding..??

[MI man]

Is there any way to protect the formulated cells and still run a macro which results ultimately in the change in values in those cells due to dependency on the macro results..??

Or is it better to write all the formulae in the VBA environment, by which no formula is visible on the cell and also cannot be manipulated from the spreadsheet end..?? (by doing this, there would not be any need to protect the cells)

 

[namliam]

protecting formulated cells doesnt protect its value, but only the value.

If the source for the formula change the value of the formula can change no problem

 

[MI man]

Hi mailman,

Could you explain it more clearly..

I meant to say....if there are macro cells as well as formulated cells...(say, some formulae written as in macro environment, such as [startdate]-[enddate], etc..and some functions that are Excel built-in have been used in a conventional way...like =SUM(A1:A10) in the cell), then if macro is clicked, both should be functioning.

But if I protect the cell that has =SUM(A1:A10) fucntion, then if I run the macro, an error is being prompted, which says that I have unprotect the cells.

If the fucntion =SUM(A1:A10) is also written in the macro environment, then there would not be any need to protect the cells...this is what I wanted to know whether it is a good practice to do this way...or is there any way wherein I can protect the required cells and still the error message skips and allows the fucntions and macros to run as usual.

Would ErrorHandler do the task...??? Or any better solution..??