Protecting the spread is not the purpose. That I already know how to do.
The objective is to "freeze" certain cells after a certain date, so that the value remains constant even if I change various operational parameters. The purpose is to retain all the cell values from before that date so that they still are relevant in the Portfolio calculations.
What I seek is very much like the Protection Function but then it should "block" all the highlighted cells from functioning. . .I call it freezing the functions.
I would still want to know if that what I want is possible. I will try to consult a rep from Microsoft Excel!
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.