i have a form control text box to get a password from user. i want to display a button named "Proceed" below the user input, if the password is matching with the same i have stored in a cell and if not matching a button named "Quit". i have created macro for "Proceed" & "Quit" buttons and they are running ok. i have tried to place the buttons in different rows and hide it with passing values and applying re-apply filter option. If the sheet is not protected, it works fine. However, i want to protect the sheet but filter re-apply do not work if the sheet is protected. Kindly suggest a solution.
Thanks. KP Menon