How to protect cells from input

[Former Member]

Hello, everybody.

Is there any feature to protect cells in BEx Analyzer 710 from user input?

In results users should not been able to type any values in these cells.

For example, one row in my report is input ready and the second one is used only for display. User may enter a value in a cell of the second row and when he presses the save button the value will be lost. This situation may upset some users. And I want to prevent it.

--

sorry for my awful English.

[Former Member · Accepted solution]

Dmitry,

I don't know if it works the same in 7.0, but in 3.5 there is an "SAP Sheet Protection" function under the Tools button on the BW toolbar.

Here is a link to the SAP Help documentation for it:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a55b8e09411d2acb90000e829fbfe/content.htm">http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a55b8e09411d2acb90000e829fbfe/content.htm</a>

Hope this helps...

Bob

[Former Member · Accepted solution]

Thank you, Bob.

If I've understood this functionality right, it allow to protect sheet at all.

But I need to protect only selected row.

[Former Member · Accepted solution]

Bob, you was right.

If I protect the workbook all cells except input-ready ones will be locked.

It is exactly what I need!

Thank you very much!!