Password Protecting Hidden Sheets

Jul 25, 2007

I am using some VBA I found here to password protect a hidden sheet. It works perfectly for 1 sheet, but I am trying to hide 6 but am having problems. Under the HideSheets part I've modified it fine, by using

Sub HideSheets()
'Set worksheet to Very Hidden so that it can only be unhidden by a macro
Worksheets("Confidential1").Visible = xlSheetVeryHidden
Worksheets("Confidential2").Visible = xlSheetVeryHidden
Worksheets("Confidential3").Visible = xlSheetVeryHidden
End Sub.........

View 9 Replies


Different Password To Unhide The Hidden Sheets.

Nov 22, 2008

I have 5 sheets, 3 of them are hidden, how can i put a 3 different password to unhide the hidden sheets.

View 6 Replies View Related

Protecting Hidden Tabs

Jan 6, 2012

So I have a hidden tab I want to keep hidden. I know how to protect a sheet/workbook but I also have a Pivot tab I want people to be able to double click to get the background detail. Unfortunately protecting a workbook doesn't allow new tabs to be created. Is there anyway of making this happen? Essentially, keep my tab hidden and allow a new tab to be created once pivot data is double clicked.

View 2 Replies View Related

Protecting Very Hidden Sheet

Dec 6, 2006

way of protecting a very hidden sheet, I will still need to open the sheet myself everytime I use the program. The only person to open this very hidden sheet is myself.

View 9 Replies View Related

Password Protecting VBA

Sep 10, 2008

I'm trying to use the Tools|VBA Project Properties dialog box to stop folks from unhiding an xlveryhidden sheet, but even though I check the "lock" checkbox and input passwords in the password and the password verify boxes, Visual Basic fails to stop me from selecting the sheet in question from an Alt-F11 spawned VBA, and editing away.

View 9 Replies View Related

Protecting Worksheets Through Password

Nov 10, 2008

Im trying to protect worksheets in a document by licking...Tools>Protection>Protect Sheet. I am also wanting to password porotect it but every time I think I have protected it, i can still click in all the cells, there are some cells that can be left unprotected....but either way I have not manged to do either.

View 2 Replies View Related

Password Protecting More Than One Worksheet

Dec 22, 2008

I have set up a workbook with a tab for each month. in the workbook open module i have the following code (below marked Password protect) that allows for three passwords to unlock certain ranges of cells, what i would like to do is for this code to apply to each worksheet.

Now in the main this works except for one range of cells H11 to H1000, on every sheet all cells are locked except for this range which is unlocked in every sheet except sheet one when you enter the password staff. The only other code i have is for a time stamp (marked time stamp) so that i can monitor when the user has entered data. this again has reference to the sheet name.

their must be something really straight forwad i am doing wrong here as everything works on an sheets except this range being locked.

I am in excel 2002 but my users are on 98, which is why i am protecting in VB rather than using the prtect range option.

View 7 Replies View Related

Protecting Worksheet - With Password

Oct 26, 2009

modify the code below to do the following:

When I recorded this macro shown below, I entered in a password (twice) as prompted by Excel 2003.

So when I run this code, it seems to work fine. However, when I want to unprotect the worksheet, I am not prompted to enter in the password.

modify the code so that when I need to unprotect the worksheet, I am prompted to enter in the password?

View 12 Replies View Related

Password Protecting A Tabs

Jun 9, 2009

I'm new to the message board so I'm not sure if this question has been addressed. I am creating an excel workbook that two groups need to provide data for, but I do not want the two groups to see each other's tab for inputing data. I know how to protect a sheet in the workbook, but a viewer can still see the contents on the sheet. Is there a way to show the tabs, but when you click on them, it automatically asks for a password before the tab contents can be viewed.

View 9 Replies View Related

Password Protecting A User Form

Nov 22, 2008

How would I code a button on a userform to request a password input before opening the form? And as a second level of protection - can I code it to only display asterick's when typing in the password.

View 3 Replies View Related

Protecting Individual Worksheets With A Password

Jan 8, 2009

Which works really well, unless when the password box comes up you click cancel. if you do it just allows you to go into the worksheet anyway.

View 14 Replies View Related

Password Protecting A Range Of Cells

May 6, 2009

How can I password protect a certain range of cells (titled 'list'), that when someone tries to edit them, a password dialogue box appears, saying only bob can edit these cells please enter password

View 9 Replies View Related

Macro To Prompt For Password When Protecting Sheet

Nov 12, 2009

Macros are just not my strong suit. I can usually find my answers here but this one has me stumped. I have rewritten this thing everywhich way but loose and this is my latest version.

Sub SetProtect()
' protect Macro
' prompts for password protection
' Keyboard Shortcut: Ctrl+p
Dim Response As String
Dim Answer As Integer


Response = InputBox("Enter password")
If Response = "safety2" Then.......

View 9 Replies View Related

Protecting Cells So That Password Is Required Only To Insert Comment

Dec 3, 2013

I've found many resources that tell me how to allow for the insertion/editing of comments within a protected worksheet. When I protect the worksheet, I can select "Edit objects" to allow anyone to insert comments.

However, my issue is that I'd like the Insert/Edit comment functionality to require a password, and this happens to be the opposite of what those resources instruct. I also want the content in those same cells to be editable by anyone.

View 2 Replies View Related

Format All Cells In All Sheets To Protection Hidden On Visible And Hidden Tabs

Feb 28, 2014

I am trying to format all cells on all sheets (hidden or otherwise) as "Locked" so when the sheets are protected the user can't see the formulas. This macro individually selects every sheet in the book and applys the formatting. Is there a way to modify this code to accomplish the same thing without having it actually select every sheet? The only reason it is an issue is that after running the macro you end up on the last sheet in the book.

View 7 Replies View Related

Can You Password Protect Hidden Cells?

Aug 19, 2009

I was wondering if it was possible to hide cells using protect sheet? I have a worksheet that contains confidential data and would like it so the cells appeared blank unless you had the password. I know you can hide rows and columns but I need everything on the sheet to be hidden.

View 2 Replies View Related

Password Protect Hidden Sheet?

Feb 28, 2013

Is it possible to have a hidden sheet password protected, so that only I can unhide the sheet ?

View 1 Replies View Related

Password Lock Hidden Column / Row

Feb 22, 2008

Is there a way to lock a column hidden so that it can't be unhidden? Maybe with a password? I tried saving the file with a password but I could still go in and "unhide" that column.

View 3 Replies View Related

Assign Password To A Hidden Sheet, Only 1 Cell Populated

Dec 11, 2006

This is my input for password prompt:

Sub CommandButton1_Click()
Dim wSheet As Worksheet

On Error GoTo ErrHandler

Currently, my excel is protected with a password "PSWD" when users open the file. In my vba script, I have a function that can unprotect my excel without any password input box to the users. This method is to unprotect the file and allow users to do any formating columns and rows tasks, such as add or delete cells. After users finish their job, the file will be protected back. The function is such as below:

Dim wSheet As Worksheet
For Each wSheet In Worksheets
Application.ScreenUpdating = False
If wSheet.ProtectContents = True Then
wSheet.Unprotect Password:="PSWD"

My questions are:

1. How I can create a hidden sheet that has one cell populated only?

2. How can I assign the password that the user enters at the "TextBox1" (first code) to a cell of of the hidden sheet? Do I have to modify the first code?

3. For the second code, how am I going to assign the value to at the wSheet.Unprotect/Protect Password:="..." with whatever the user has previously chosen as a password that refers at the hidden sheet?

View 9 Replies View Related

Opening Password Protected/hidden Worksheets By The Manager

Oct 4, 2007

I've looked through this wonderful sight and haven't found one close to my project. I am a bit rusty on VB programming. I am working on workbook that contains multiple worksheets. Each worksheet is hidden and is accessible with a login and password so that only a specific user can access. My question is: How do I modify this so that the manager can open the workbook and view ALL worksheets without having to enter the login name and password for all of his users? Any help would be great. Thank you!!

Below is what I have so far: ....

View 9 Replies View Related

Protecting All Sheets

Jul 1, 2007

I am trying to protect all sheets on a Workbook Close event.

I don't want the user to even be able to Select the Loked cells so I set it up that way through formating of cells.

This is what I have tried:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
sh.Protect Password:="P@ssword", DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells
' sh.Protect Password:="P@ssword"
Next sh
End Sub
I even tried the commented out line in that postion instead of where it is now.

It does protect but still allows selection of locked cells.

View 9 Replies View Related

Unprotecting And Protecting Sheets

Nov 18, 2008

I currently have set up two macros that will unprotect and protect all sheets. When I run the macro I noticed that it will not unprotect the sheets that have been set as a new sheet for the chart (the chart is not a object in a sheet it is a sheet all by itself) Can anyone tell me where I have gone wrong?

View 14 Replies View Related

Protecting Sheets [Macro Fix]

Jan 22, 2010

Private Sub Worksheet_Activate()
ActiveWindow.WindowState = xlMinimized
If InputBox("Pleas enter the password: ") "Password" Then Sheets("OkToSeeThisOne").Activate
ActiveWindow.WindowState = xlMaximized
End Sub
This is the code i enter into 3 sheets that i don't want ppl to see unless they know the password but if they press cancel the End on the debug error they can view the sheet lolz. How can i stop them actually viewing it at all?

View 9 Replies View Related

Protecting Sheets With Multiple Passwords?

Jan 29, 2014

I have different sheets in my workbook for which i have different passwords with which i need to protect each sheet with the password assigned to it.

Is it possible to do a macro which automatically protect the sheets with the correct password.

I have attached a sample workbook the sheet "passwords" will have sheet names in first column and respective passwords in the second column.

View 6 Replies View Related

Hiding Sheets But Still Letting Macros Run When Printing Hidden Sheets

Nov 10, 2008

i have a workbook that has the following sheets

working sheet
job sheet
receipt of deposit letter
completion sheet
delivery note
delivery note (2)

i want to hide every sheet except the working sheet.
I have tried this but the macros bring up an error when i run the macro

my macros involve printing certain pages dependng on what button is pressed

i get an error whatever
how do i stop this

View 14 Replies View Related

Username And Password Form - When File Is Saved By Any Users All Hidden Files Get Unhidden?

Mar 23, 2014

I have Excel Sheet that open with user name and password.

Like if it's open my Admin - he can view all Sheets

If open by any user - it opens only users sheet.

Problem is once file is saved by any users, all hidden files get unhidden and Admin Sheet is open.

Requirement: if User1 saves file other sheets should not get unhidden.

View 1 Replies View Related

Hiding Protecting Sheets After Someone Clicks On Cell

Jan 5, 2013

I have a sheet that pulls data from an external source. I want it so that when a person clicks on a cell or a range of cells, it automatically locks and hides the formula. I don't want to lock it by using the conventional method because protecting it will cause the external data not to be able to populate the cells. So my thinking is that when the data is imported, and the user clicks on a cell, it will automatically lock and hide.

I need columns

A C E:BB to be locked and hidden as soon as someone clicks it. Is this possible?

I read somewhere that I may be able to do some type of "Private Sub Workbook_SheetSelectionChange" to achieve this.

View 3 Replies View Related

Macro Protecting Multiple Sheets In Workbook?

Sep 6, 2012

I have a large workbook with 10+ sheets i need to protect all at once. I have created a macro in VBA below. It works, but I would like another user to be able to change formatting on the sheets while they are protected. below is my macro.

Sub ProtectAll()
Dim wSheet As Worksheet
Dim Pwd As String


View 1 Replies View Related

Very Hidden Sheets Are Very Hidden

Jan 2, 2007

i have an old spreadsheet that i created about a year or so ago.
i managed to make some sheets "very hidden" as opposed to just "hidden" or "visible".

the problem is i can't find them ! i have tried "format, sheet, unhide" but that is greyed out.

i do have passwords for them, but i can't find them to put these in!

View 9 Replies View Related

Hidden Sheets

Oct 3, 2008

I have a 15 sheet spreadsheet that has many formula and results that are obtained from a "Master Sheet." I want to hide the "Master Sheet" from users view.

When I do so the formulae can't find the info they require. How do I hide a sheet so that users can't see it, but the formula from other sheets can still access it?

View 4 Replies View Related

Copyrights 2005-15, All rights reserved