Skip to Content

Hide filter pane of EVCVW function

Hi,

We use the function EVCVW(AppName, Dimension, FilterList).

=EVCVW("PRESU";"ENTE";"TIPENTSEC95=A")

When we double click in a cell containing the function, it shows the pop-up with the dimension members and filter pane.

We want to hide this filter pane so that the user can not change options that we have put in the parameter FilterList of the function EVCVW.

Best regards,

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 02, 2012 at 01:35 PM

    Hi,

    if you want to block any change to the filter in the EVCVW of your report, just check blocked on the cell format and add a psw to your workbook options on the "Set worksheet psw".

    If you want to block any change from the CV then click on "Action pane/Schedule Tasks/Worksheet dimension lock Options" and after check the dimension that you want to block.

    Best regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 02, 2012 at 02:46 PM

    Hi Roberto,

    the cell that containts the EVCVW function is blocked and the workbook has a psw.

    with the EVCVW function the user can choose from a list of the dimension member a certain property which are equal to a certain value.

    we want to block or not shown on the right side of the window for selection of members.

    we know there is a button that shows and hides it, but even hide it using the EVCVW function is always displayed when you double-click

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Gorka,

      it isn't possible to hide but with the blocked cell and psw on the workbook option you are sure that they couldn't change your filter and as I wrote before to block any change from the Action Pane on the right, click on "Action pane/Schedule Tasks/Worksheet dimension lock Options" and after check the dimension that you want to block.

      So the blocked dimension will be grayed and it isn't possible to change from there.

      Best regards

      Roberto

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.