EVDRE Formatting: CRITERIA is INPUT and USE is LOCK

[Former Member]

Hi

Goal : lock calculated cells for input on a BPC EVDRE input schedule which is dynamic in rows and cols

What should my format range look like and what is my protection setting?

Thx

Bjorn

[Former Member · Accepted solution]

Hi Bjorn,

You format range should look like the following

CRITERIA EVALUATE IN FORMAT USE PARAMETERS APPLY TO

CALC 123 LOCK DATA

You should lock the cell with the "123" (Format Cells / Protection / set tick in "Locked")

After that, go to the "Workbook Options" and set a password.

Regards,

Marcel

[Former Member · Accepted solution]

Hello,

How could you describe the Skydex Soft Ltd(www.skydexsoft.com) activity? It is the highest

quality and fast delivery! This is exactly what is needed! There is

nothing else to add! I have not seen any other company who would pay

so much attention to clients. It is just a simple pleasure to work

with them. They actually are the best in the business! I thank God

that I came to know this company when I was looking who to use to

execute my project. So if you want a qualitative decision of your

problem u2013 you can use this company without any doubt. They have a lot

of talented professionals working there

yours

Jeanne Scheffel