O
omega
Hello!
Please help. Is it possible that a macro prompts a password when the user
selects a certain worksheet? Below are the details:
• I have a macro that automatically selects Sheet1 every time the user opens
the excel file. Sheet1 is acts as the main page.
• Since I am using macros, I don’t want to strictly protect the sheets with
the regular excel 2007 worksheet protector.
• However, Inasmuch as I don’t want to hide Sheet2, I don’t want everybody
to just use it and make changes without a password.
• I am looking at the following macro tasks to protect Sheet2:
01. When the user clicks Sheet2, Sheet2 displays.
02. Then, a password box pops out quickly and asks for a password.
03. The password characters should be hidden by dots or asterisks
for further security.
04. When the password is correct, a macro prompts the user that
the sheet is now ready to use, then the prompt fades out.
05. When the password is NOT correct, the macro prompts the user
to retry the password.
06. When the password is already correct, the macro does task #04.
07. When the password is NOT correct for the second time, the
macro selects back Sheet1.
• The whole “password†prompting task should be inescapable by esc or
whatever key strokes.
I hope this is possible. Please let me know where to put the codes as I’m
still new to Excel 2007.
Thank you,
omega
Please help. Is it possible that a macro prompts a password when the user
selects a certain worksheet? Below are the details:
• I have a macro that automatically selects Sheet1 every time the user opens
the excel file. Sheet1 is acts as the main page.
• Since I am using macros, I don’t want to strictly protect the sheets with
the regular excel 2007 worksheet protector.
• However, Inasmuch as I don’t want to hide Sheet2, I don’t want everybody
to just use it and make changes without a password.
• I am looking at the following macro tasks to protect Sheet2:
01. When the user clicks Sheet2, Sheet2 displays.
02. Then, a password box pops out quickly and asks for a password.
03. The password characters should be hidden by dots or asterisks
for further security.
04. When the password is correct, a macro prompts the user that
the sheet is now ready to use, then the prompt fades out.
05. When the password is NOT correct, the macro prompts the user
to retry the password.
06. When the password is already correct, the macro does task #04.
07. When the password is NOT correct for the second time, the
macro selects back Sheet1.
• The whole “password†prompting task should be inescapable by esc or
whatever key strokes.
I hope this is possible. Please let me know where to put the codes as I’m
still new to Excel 2007.
Thank you,
omega