About Us

Don't worry I figured it out.

Thanks anyways,

Dave

"coddave" wrote:

Hi Norman,

Thanks for the help! I also required some information to be restricted. Out
of curiosity after unhiding the cell, how do you go in at a later time to
change the password? When I click on the sheet it continues to bring the
password screen up over and over. Is there a way to select on the tab and
click view code again?

Sincerely,

Dave

"Norman Jones" wrote:

Hi Michael,

one line of Hayeso's code has wrapped making it appear as two lines. To
obviate the problem, replace:

If InputBox("Please Enter the Password for the " & Me.Name & " Sheet",
"Enter Password") < Password Then

with:

If InputBox("Please Enter the Password for the " _
& Me.Name & " Sheet", "Enter Password") _
< Password Then

---
Regards,
Norman

"Michael Link" wrote in message
...
Hi--

Actually, I just had a few minutes to try to implement this.
Unfortunately,
I'm gettiing a "Syntax Error" message, indicating that there's an
end-of-statement issue. Might you have any ideas what the issue is?

Thanks!

"Hayeso" wrote:

Right Click the Sheet tab and select "View Code" then add
the following code. You can change the password to whatever you like.

Private Const Password As String = "DoubleOhSeven"

Private Sub Worksheet_Activate()
Me.Visible = False
If InputBox("Please Enter the Password for the " & Me.Name & "
Sheet",
"Enter Password") < Password Then
Me.Visible = False
Else
Me.Visible = True
End If
End Sub

"Michael Link" wrote:

Is it possible to protect a sheet in a workbook so that it isn't even
viewable unless you have the password? One of the sheets in my workbook
contaiins highly sensitive information that I don't want most folks to
see,
but I want users to be continue to hide and unhide other elements in
the
workbook to fit their needs.

Is there something I can write in VBA that will do the trick? In the
perfect
world, what would happen is that, when a user clicked on the tab for
the
Sensitive Sheet, a popup box would appear asking for a password. Is
this even
possible?

Help! Any answers would be much appreciated.

Cheers!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sheet Protecting password	Nick	Excel Discussion (Misc queries)	1	June 30th 05 12:43 AM
Copying multiple sheets from one book 2 another and undertake spec	Pank Mehta	Excel Discussion (Misc queries)	14	March 16th 05 04:41 PM
Protecting a sheet that includes a solver function	20002238Rijk	Excel Worksheet Functions	3	December 9th 04 09:53 AM
Protecting a sheet that includes a solver function	20002238Rijk	Excel Worksheet Functions	0	November 11th 04 01:44 PM
Naming & renaming a sheet tab	Cgbilliar	Excel Worksheet Functions	1	November 7th 04 05:57 PM

Menu

About Us