Some time back I got a mail from my superiors saying that the company was trying to get an ISO certification and everyone was required to "conform" to the standards and be cautious with the client’s data. Like others, I “cleaned up” my Mac and I was back to my work again. Then I got another mail saying that I needed to protect the Xcelsius Dashboard sitting in our Shared drive.
So I got to work and came up with this.

Without the Password this dashboard is not clickable.Try any wrong password then try Password: xcelsius.

The logic behind this is to use a layer which stops the users, without the password, to use the dashboard. When the user enters the correct password, the layer disappears (using dynamic visibility) and the dashboard becomes accessible.
Components used:
1.     Backgournd (any)
2.     Label & Input Box
3.     Toggle Button or Push Button
4.     Image Component

These are the steps to be followed:
  1. 1.     For this trick I am using the dashboard created in the Pivot table Functionality Post.

    Cover this dashboard with a Background of your choice. Right click on the background, go to Properties>General Tab.  Increase the transparency of the background to around 40% (you can change this percentage according to your convenience, you can have 0 transparency if you do not want any of your dashboard to be seen without password)

    1. 2.     Use a label(1) to give a note to your users (Here I have used “ENTER PASSWORD TO VIEW DASHBOARD”). Then use an Input Box below this, as shown in the figure, and do the following changes to the properties:
    a.     In General Tab Click on the radio button next to “Enter Text”. Go down and give destination as B29 (say).
    b.     Click on Behavior tab>Common and “check” the check box next to “Treat All Input As Text” & “Enable Password Protection”. The “Enabling” password protection will make sure that the letters when entered appear as astrix.
    c.     Now we use a Push Button or a Toggle button. With source data as ‘A31’ and Destination data as ‘A33’. I’ll explain why these cells are used.
    1. 3.     Now we come to the Excel sheet. The password used here is XCELSIUS; enter this in the cell A29. B29 cell (input from Input box) is then converted to Uppercase in the Cell A31, using the formula ‘=Upper(B29)’. This is the source data for Toggle button. The toggle button, when pressed, puts this value in Cell A33.
    1. 4.     The above steps will put the password into the cell A33. Now we’ll take care of a wrong password entry. What we want is to have a “Cross (wrong symbol)” appear when the user enters a wrong password and we want to tell the person to “TRY AGAIN”. So an image of an “Cross” along with a label(2) is placed next to the input box. Its dynamic visibility is set so that these two appear when the cell A33= (basically the input from input box in caps) is not blank and is not equal to A29( which has the password ‘XCELSIUS’ written). Thus to achieve this, I group the label(2) and the picture, put status in properties>behavior>common as ‘A35’ and key as 1. Then in A35 I use the formula “=IF(AND(A33<>"",A33<>"XCELSIUS"),1,0)”.
    1. 5.     Finally, you need to group a) The Background b)Label(1) c)Inputbox d)PushButton. you need to set their dynamic visibility such that these disappear when the password entered is correct and the button is pushed. So when the button is pushed cell A33 gets populated with what is entered in the input box. In cell B33 I have used a formula “=IF(A33=A29,1,0)” . A29 is the cell which has the password “XCELSIUS” written in it. So for the group, go to properties>behavior>common and put status as B33 and key as 1. Once you do this click preview and you have a protected dashboard with a password.

    1. gravatar

      # by Anonymous - November 10, 2010 at 6:36 PM

      many thanks - this is very helpful! quick question: is there a way to use case sensitive passwords?

    2. gravatar

      # by Analyst - November 11, 2010 at 4:15 PM

      Yes there is.. instead of using '=upper(B29)', just use '=B29'. This will make the password case sensitive. Let us know if you need anything else.

    Blog Widget by LinkWithin

    Search this blog..