Planning sequences as buttons in my workbook.

[Former Member]

Hello all

I am using input ready workbooks (Bex 7)for planning. I am using Planning sequences as buttons in my workbook. the only way i know to fill the variables of the sequences, is by write the values on the excel, and in the "command range" i write the range of the data.

The problem is that: i want to lock the workbook by password. When i do it, the user cant change the values of the variables.

What else can i do?

Best,

Yuval

[Former Member]

You can exclude single cells from locking. Right-click on the cell and choose "Format cell" or "change formatting" (don't know what it is in English version). There is a register protection where you can change the protection flag. So if you lock the workbook later, these cells stay editable. This works also when you set the locking with the analyzer option.

Tip for variables and command range. In the command range put a reference to another cell and hide the command range.

so the user edits the variable in another cell.

e.g. command range in A3 to C3. and C3 has "=F5". Now hide row 3. And make F5 editable for the user.

Regards,

Lars

[Former Member]

Hi,

There is one solution for this. Try out the following steps.

1. In BPS0 transaction, make the variables as user defined variables. However, "input allowed by user" should be unchecked.

2. Give the possible values to the variables only with your user ID.

This way, only you have the authorization to give values to the variables. Any other user won't be able to change this value.

Please award points if helpful.

[Former Member]

Hi,

You can do this with the help of normal protection concept. Goto Tools -> Protection -> Protect Workbeek.

Please award points if helpful.

[Former Member]

hi nilanjan

I dont think this locking concept helps me. i see that the user still can change things in the query. What exactly is it suppose to lock?

Best

Yuval