Button with pass word enter to access certain page

[paulyeo11]

Hi All

I have a sheet which is important information only access by top mgt people , and when user click the button , it will ask for pass word . may i know how to do it ?

Paul

[#2]

The sheet opens even if u clear the password. It means that it is not ok to write =$(vPassword)=12345 and u need to use vPassword='12345'

[paulyeo11]

Hi yad ,

i just like to know how you know 1=1 will be able to hack it. i just like to know what it the logic.

[#4]

Because u saved the document when the password is entered. Normally, users are not allowed to save the document, only developers can do it.

Still I suggest u to use section access. It will be much  more secure.

[paulyeo11]

Hi she

Pls send me your excel file. Thank you for your code.

[#6]

When u use syntax like that $(vPassword), the dollar sign expansion calculates what it is inside the brackets. So when u enter 1=1 and the condition says $(vPassword)=12345, the result is True()=12345 which returns null() value and the sheet opens.

[paulyeo11]

Hi Yad

Thank you very much. look like not easy understand for non programmer.

[#8]

Find attached.

[paulyeo11]

Hi she

i set the caption tab text to white but still see the password. may i know how you change the color to white ?

[#10]

You need to change row color: Properties -> Presentation -> Row Colors

[paulyeo11]

Hi She

I am using ver 9 so i am not able change the color , you must be using higher then 9 right ?