Password Protect Worksheets From Viewing

Jan 3, 2007

Here is what I try to achieve:

- I have a "Menu" worksheet with basic Hyperlink to Sheet1, Sheet2 etc.

- When I click on a link (or on the tab), I want a prompt asking for a password (different for each tab). I do not anyone who doesn't have the correct password to see the content of the worksheet.

(I don't know VBA and I couldn't modify the code to fit my needs)

Here is the code posted


Dim sLast As ObjectPrivate Sub Workbook_Open() 'Ensure Sheet1 is not the active sheet upon opening. If Sheet1. Name = ActiveSheet.Name Then Sheet2.SelectEnd

View 9 Replies


ADVERTISEMENT

Password Protect Viewing Of Individual Worksheets?

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

Password Protect Viewing Of Individual Worksheets

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

Password Protect Sheets From Viewing

Sep 12, 2006

I have a excel file with around 8 sheets in it and this file puted in the network to be shared with 8 persons So i need to make an individual password for each one to enter to his specific sheet and have full authorization to make anything in it and this done using userform where each one when open the file in the network , a user form open in first stage to select his name and put his own password with the ability to let each one to make his own password or change it from the userform

this file is shared so it may more one user open it and it may be there an save funtion at same time ( same time & same activities )

View 9 Replies View Related

Excel 2007 :: Hide Sheets On Opening And Password Protect Viewing

Nov 1, 2009

I have an Excel 2007 workbook which has five sheets in. I just wondered whether it is possible to hide all five of them when the workbook is first opened. Also I would like the user to be asked for a password when they wish to unhide a sheet, with the password being different for each of the sheets.

Is there also a way to do this which won't be affected by Excel disabling all Macros when the application initially opens.

View 6 Replies View Related

Password Protect Worksheets

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

Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?

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

Protect Sheet From Viewing?

Jan 18, 2012

I have a workbook with several worksheets. I need to prevent users from viewing worksheet mgrview unless they have a password for it.

View 1 Replies View Related

Protect Workbook From Editing / Viewing

Feb 14, 2008

I have placed a workbook on a network drive. This workbook contains sensitive information and I would like to protect it to a "feasible" degree. I have written the following code

Private Sub Workbook_Open()
Dim userid As String, valid_userid As String
Dim i As Integer
valid_userid = "MISI01/"
userid = GetUserName()
userid = UCase(userid) & "/"
i = InStr(1, userid, valid_userid)
If i = 0 Then
MsgBox ("You are not authorised to use this workbook")
ActiveWorkbook.Close False
Exit Sub
End If
'create menu when workbook opens
Call Module1.CreateMenu("")
Call Modul1.check_filedate("")
' This will disable the user from moving, renaming etc the sheets
ActiveWorkbook.Protect Structure:=True, Windows:=False
End Sub

As can be seen from the above code, I check if the current userid is one of those that are valid to open the workbook. If not the idea is to tell them and close the workbook immediately (this bit isn't tested yet). This code is not supposed to be hacker proof, but to prohibit the casual user from reviewing the the data.

View 3 Replies View Related

Password Protect Columns - Hide And Protect Ability To Unhide

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

Viewing Worksheets In Full Screen?

Oct 30, 2011

I have large workbook with various sheets. In my first worksheet I have some command buttons that call each sheet as needed. However, I would like each sheet to be displayed either as a web page or in a way that the user does not see all of the menus, bars and so on.

View 1 Replies View Related

Viewing And Printing Selected Worksheets - VBA

Sep 3, 2009

I have a workbook containing a number of spreadsheets. Some of the spreadsheets are user inputs. The results of the user inputs drive a number of final reports. The final reports (i.e. spreadsheets) are hidden from the user (I don't want the user to be overwhelmed with so many tabs when they open the excel spreadsheet).

I created on the main input tab spreadsheet the following:

1. Check boxes - so that user can select after making his/her inputs the reports that he/she wants to view or print.

Say there are 4 reports (call them Sheet1, Sheet2, Sheet3, Sheet4 - therefore, 4 check boxes. Through the Format Control, the checkboxes have cell links that yield TRUE (if selected) or FALSE if not selected - linked to cells A1, A2, A3, A4 respectively.

2. Option buttons - one for view and another one for print. Through the Format Control, the View and Print option buttons have cell links to cell A5 yielding 1 for View and 2 for Print.

3. Command button - that will clear the check boxes

Issue
I would like to know if there is a way to code in VBA to:

1. Unhide the spreadsheets corresponding to the check boxes if selected;

2. Print the spreadsheets corresponding to the check boxes if selected for printing; and

3. Clear the checked boxes to unchecked if the Command button is clicked.

I'm struggling with coding to perform the above tasks.

View 9 Replies View Related

Protect VBA Project Or Lock Project For Viewing By VBA

Apr 27, 2007

I have tried to record macro to protect VBAProject / lock project for viewing. But can not success by that way.

View 9 Replies View Related

Password Protect A Tab

Dec 9, 2008

is it possible to password protect a tab (worksheet) within a multiple worksheet file.

View 9 Replies View Related

Password Protect One Cell

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

Password Protect The Spreadsheet?

Nov 30, 2009

I need to make my spreadsheet require a password to open. How do I do this?

View 2 Replies View Related

Password Protect A Macro

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

Password Protect Macro

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

Protect The Sheet With Password

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

Protect Workbook No Password

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

Protect Worksheet With Password

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

VBA - How To Protect Sheet With Password

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

Protect The Worksheet With Password

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

Password Protect Tabs

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

Password Protect W/ Expiry

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

Password Protect Macros

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

Password Protect Sub Procedure

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

Password Protect To Open Worksheet

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

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

Set A Password Under The Permissions Tab But All It Does Is Protect The Structure?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved