Password Protect Individual Tabs?
Jul 17, 2007
I have a spreadsheet with a number of different tabs. I need to be able to set a password for these tabs so nobody can access the other ones except with a password. It needs to be an easy way to do it as senior managers are going to be using the spreedsheet and they wil only want to enter a password to have the sheet appear in front of them!!
I have seen a thread posted before about a macro that can be used to set password for each tab. The trouble is I have no idea how to get it to work !! Can any body help me as my VB knowledge is extremely limited!!
View 9 Replies
ADVERTISEMENT
Dec 1, 2009
I would like to adjust the code found in the attached thread so that i can allow one person access to more than 1 sheet
Password Protect Viewing of Individual Worksheets?
View 9 Replies
View Related
Nov 6, 2009
I have a file w/ individuals monthly sales information (per worksheet) that needs to be distributed in one mass email to the entire sales force. I want everyone to have access to the "Summary" tab, but individuals should only have access to their own "Details" tab. I know there has to be a way to accomplish via VBA. However, I'm not proficient in writing code.
View 9 Replies
View Related
Mar 23, 2004
I have one workbook with different Tabs that are tied to a master sheet. Different offices are respondable for entering their office information I was hoping instead of seperating the tabs into different workbooks and linking to the master, I could password protect each office tab. Can this be done?
View 9 Replies
View Related
Jan 12, 2007
I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.
Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub
View 3 Replies
View Related
Jan 17, 2013
Some sensitive data is held on worksheets that are used by people that do not have access to see the data.
It would be most convenient to keep the data in these worksheets but hide it from view of the users.
Is there a way to password protect a users ability to unhide a column?
View 2 Replies
View Related
Mar 17, 2007
I am running a loop that changes the value in one cell at a time. Since this is for our entire company, I am trying to make it "idiot-proof" like most of you have done.
While in the loop, I want to unprotect a cell, change the value, then reprotect the cell. But the rest of the worksheet is going to be unprotected for now. is that possible? Or do I have to protect the whole sheet, and then .Unprotect the whole sheet first and then. Protect it at the end of the macro.
View 3 Replies
View Related
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
Jan 9, 2010
Is there anyway I can make it so that each individual sheet in my workbook has a different password?
View 9 Replies
View Related
Jan 8, 2010
From a master (data entry) spreadsheet of work projects, I'd like to automatically create a tab for each individual contributor that lists all projects they are involved with. The thing is that being a contributor can mean being the lead, assisting with, or being the technician on the project (all columns in the master). To make the individual tabs easier to read, it'd be great to have that tab's contributor name in red, wherever it happens to fall in the various columns.
I've created an example that's a little simpler than reality - in real life there would be 20 tabs for the individual contributors and instead of 3 "Assist" columns there would be 20 columns.
View 7 Replies
View Related
Dec 9, 2008
is it possible to password protect a tab (worksheet) within a multiple worksheet file.
View 9 Replies
View Related
Mar 15, 2007
i want to protect or give password in only one cell plz let me know how can i do this reply me as soon as possible
i m in touble to give password in one cell i want when i try to put any thing on that cell it will
View 11 Replies
View Related
Nov 30, 2009
I need to make my spreadsheet require a password to open. How do I do this?
View 2 Replies
View Related
Oct 24, 2007
I currently have a macro which i run by selecting tools, macro, macro and then selecting the one i want and pressing run. if i press run I want a box to appear asking me to input a password and if password matches then run that specific macro, can this be done
View 2 Replies
View Related
Oct 22, 2008
Is there a way to password protect the macro code, so that someone can't open the coding?
View 4 Replies
View Related
Feb 5, 2009
I am seeking a method of password protecting worksheets in a workbook. The users would all start on a sheet that has their names (A1 - A10) next to their names would be where they type in their password (B1 - B10). If their password is correct their assigned worksheet (Worksheet2) would be unlocked for editing.
View 11 Replies
View Related
May 12, 2009
1) I need to have code to protect the sheet that my user form is writing to. In other words, when the information from the user form is populated to the sheet, I want that sheet protected by a password that I set where I can unlock it, but no one else can.
2) I need to protect my VBA code with a password, I do not know how to do this, I have looked everywhere. I do however think this is something simple and I will kick myself once I find out where it is.
View 6 Replies
View Related
Jan 11, 2010
I have a workbook that contains a series of macros designed to compare various reports and spit out a report. I don't want my users to have to insert a password, but I want to keep my workbook protected. I've already protected the macros in the VBA Properties, so those are pretty safe, but the worksheets in the workbook are susceptible to changes that will hose my macros.
Setting the workbook to "Read Only" in Properties on our shared drive helps, but any user can change that at will. Within Excel, going to Options, Security, I can set a password so no-one can modify that workbook, but that pops up a password box when they open the workbook. I'd like to NOT have the password box pop up unless I need to make changes. Is there a way to do that? I've looked on the internet but can't find a solution on this one.
View 5 Replies
View Related
Jan 21, 2010
the user is prompted with a password inputbox to both protect and unprotect my worksheet named: Data. I am using Excel 2003.
View 3 Replies
View Related
Jul 2, 2012
the following macro, changes a few cells etc, then protects the sheet.... however I wanted the protected sheet part to have a password "Sausage"...
macro, so it protects the sheet with a password as "Sausage"
Sub RATIFY1()
'
' RATIFY1 Macro
'
'
Sheets("Outline Generator").Select
ActiveSheet.Unprotect
Range("E6").Select
ActiveCell.FormulaR1C1 = "Outline Ratified"
[Code]....
View 5 Replies
View Related
Jun 7, 2008
I had the thought that maybe it would be possible to have a worksheet that is not protected when saved but when it is opened there would be a sub-routine under Sub_Workbook Open that would step through each sheet and assign a random password. And when the workbook is saved it is saved without passwords again.
In this way there would be nothing for a password cracker to pick at. The only flaw I see would be that the password to open the VBA module would need to be static and this would open up the programming to change and remove. But wouldn't this be effective against most users who would only know about the utilities to open the passwords and not the programming behind excel.
View 9 Replies
View Related
Jun 18, 2006
We are making a complex financial calculator that we will let licensees use for a limited time.
The calculator could be an online php form, however we decided to go with excel for its ease to program the code required.
Question is:
Since the licensees are allowed to use the calculator only for a short period of time, we want to be able to password protect it with an expiry date.
Meaning that if they want to use it pass their time limit, they would need to re-enter a new password that we would provide them.
Is there such an application made for excel worksheet?
View 5 Replies
View Related
Dec 4, 2007
I need to protect a macro so that it's code can be viewed only by authorized users.
View 2 Replies
View Related
Feb 14, 2008
Is it possible to put a password lock on a command button i created in excel? If so, how would you do this?
View 2 Replies
View Related
Jul 22, 2008
I know of the password protect feature to open a excel file or workbook, but does anyone know if this can be done for opening a worksheet.
I want to be able to view a worksheet after a password is entered, so therefore different worksheets have different passwords.
View 9 Replies
View Related
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
Dec 3, 2012
I have set a password under the permissions tab but all it does is protect the structure and not the content. I want all users to be able to view the file, but have to have the password to edit any of the sheets or data on the sheets. I can still protect the individual sheets, but that doesnt quite do what I want.
View 1 Replies
View Related
Feb 21, 2008
This question is related to my post here:
http://www.excelforum.com/excel-programming/634024-cell-range-protect-unprotect-toggle.html
When you protect a worksheet via VBA then unprotect it the conventional way via: Tools>Protection>Unprotect Sheet. Why is it when you unprotect a worksheet in this way Excel does not ask you for a Password. You simpy only have to select Unprotect Sheet and the sheet is unprotected which for me kinda defeats the object.
View 10 Replies
View Related
Sep 10, 2009
I have recorded the following macro and wish to add unprotect (with password), run the macro - which formats the worksheet and then password protect all cells with the exception of range E15:H413 which I want to leave editable by users.
View 9 Replies
View Related
Mar 15, 2012
I'm looking to password protect the sheets in my workbook (using vba) but I can't seem to join this up with allowing users to edit scenarios.
If I record the protection I get this:
Code:
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False
I normally use:
Code:
ActiveSheet.Unprotect Password:="password"
I just need to combine the two. Adding the password before 'DrawingObjects' or at the end doesn't seem to work.
View 5 Replies
View Related
