Skip to Content
avatar image
Former Member

Planning sequences as buttons in my workbook.

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 17, 2008 at 10:06 AM

    Hi,

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

    Please award points if helpful.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 17, 2008 at 01:23 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2008 at 03:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded