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.
2. Label & Input Box
3. Toggle Button or Push Button
4. Image Component
- 1. For this trick I am using the dashboard created in the Pivot table Functionality Post.
- 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:
- 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.
- 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)”.
- 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.
This entry was posted on Mar 26, 2010 at 10:20 AM and is filed under Xcelsius, Xcelsius- Background, Xcelsius-Dynamic Visibility, Xcelsius-Input Box, Xcelsius-Password Protection. You can follow any responses to this entry through the RSS 2.0. You can leave a response.