I want to be able to have a prompt password to view a sheet
2006-08-09 12:50:35 · 2 answers · asked by tom 1 in Computers & Internet ➔ Software
Set the Visible property of the sheet to xlveryhidden using visual basic code. This way the sheet will not be visible.
Sheets("Sheet1").Visible = xlveryhidden
Use the Inputbox to ask a user for a password. If it matches then set the property to True
Sheets("Sheet1").Visible = True
I hope it helps. If you want it in more detail contact me
2006-08-09 20:11:49 · answer #1 · answered by Dilip Rao 3 · 1⤊ 0⤋
If you want to password protect the file, there should be an option when you save it. If you need to get back to that screen, choose File->Save As... and then save the file with the same name as it has now.
I don't know how to protect individual sheets.
2006-08-09 20:05:27 · answer #2 · answered by Bryan A 5 · 0⤊ 0⤋