Password Required To View Sheets
Oct 11, 2007
I have a spreadsheet which is used for STAT purposes at work, there are 14 users who use this spreadsheet.
The sheets are named after a user, i.e my sheet is under 'Steve'.
The problem I have is, I have a sheet thats unhidden on the spreadsheet (the rest are all hidden)
What i want is a form to open and request a username and password, or to gain the user name from there windows logon.
After the spreadsheet has recoginsed whom is entering the sheet, i want the spreadsheet to display there individual sheet, and keep everyone elses hidden.
I don't want them to have access to any sheet other than there own.
I then want an administrator logon, where that person can see all sheets.
View 9 Replies
ADVERTISEMENT
Mar 13, 2008
I have a workbook which, on opening, shows a logon form and depending on the username and password entered only certain sheets open - there are about 10 usernames and passwords - i have only included 2 to keep the code a bit shorter. I got the code below from here and it works perfectly but I want to make it a bit easier to add new usernames and passwords and am thinking of using a Vlookup table. The code i currently use is:
Option Explicit
Const sName1 As String = "Lisa"
Const sName2 As String = "Philip"
Const sPw1 As String = "update"
Dim sPW As String, sUser As String
Dim sMsg As String, sTitle As String, sStyle As String
Dim iCounta As Integer
Private Sub cmbValidate_Click()
sTitle = "Incorrect Password"...........
View 5 Replies
View Related
Oct 17, 2008
I would like the user to enter a password to unhide a column. I am aware of how to use a password to unhide a worksheet, but now I would like just a column.
View 9 Replies
View Related
Mar 28, 2012
I am trying make a macro required a password to run.
I found this code below but not sure how to use it. I would like to be able to run it from a command button.
Sub MPW()
Dim My Password
My Password = InputBox("Please enter password", "Password Prompt", "********")
'Hardcode password
If MyPassword = "password" Then
MsgBox "Access Granted", vbInformation, "Access"
'call macro
Exit Sub
Else
[code]...
View 3 Replies
View Related
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
Aug 11, 2008
I am using some protected workbooks and cannot see the tabs at the bottom of the screen.
I have tried going to tools/options/etc
I have tried viewing full screen
If I copy the current sheet 1 and paste it into a new workbook I can then see tabs (but only sheet 1 has copied data).
View 14 Replies
View Related
Dec 4, 2006
how can i see hidden sheets in a workbook?
View 3 Replies
View Related
Dec 22, 2009
I have an excel document with about 7 worksheets in it. The users of these worksheets can save the document but they never save it with the page view starting from the top. How can i ensure that whenever this document is open the default view for all the contained worksheets is at the top (ie:cell a1).
View 2 Replies
View Related
Jun 11, 2007
Remember Lotus used to do this?
I have on one sheet - 600 rows of financial products by 100 regions worth of $ balances and on another identically formatted sheet the associated interest rates.
I just want to page down on the $balances tab and have interest rates tab move in sync - letting me eyeball the related info.
I've tried searching for an hour to come up with the right terms - split, freeze, etc.
View 9 Replies
View Related
Nov 29, 2007
I have a workbook with 3 spreadsheets. When I put ptotection on 2 of the sheets, the custom view will not work on the other. Any way to make the views work?
View 5 Replies
View Related
Jul 16, 2013
sum all my sheet data....I have around 200+ sheets with same format and I'm doing one summary sheet where I can see the sum of all sheets (column L) but not able to get the formula .....
Example: Currently using below formula
=Sum('Sheet 1'!L:L)
How to I change the Sheet 1, Sheet 2 ..etc If I drag the formula I'm not getting the results....
get the right formula to copy all the sheets column L:L sum details...
View 6 Replies
View Related
Feb 18, 2014
I have a workbook that is setup with headers and footers. To the right, left, and below the worksheet there are other pages greyed out pages that are not being used. Is there a way to change the view and potentially remove these "other sheets?"
View 3 Replies
View Related
Nov 29, 2012
I have an excel spreadsheet I have created as a printable form. It all fits nicely onto one page. I would like to be able to email it to people and have it look like a one-page form. It looks great in Page Layout view, but the only problem is that there are a bunch of extra sheets that show up as well. Is there any way to remove/hide these extra sheets that are not needed? Or is there another way to send this out so that it comes to folks as a one-page form so that they can alter the data in the cells but not the page formatting?
View 1 Replies
View Related
Feb 24, 2014
What i am trying to do: Create a login option to filter what worksheets each user can see. I need the users to be able to view 2 sheets not just 1. Also i need an admin login that can view all sheets. I want to keep the workbook protected so even though they can see and edit those two sheets they can only edit certain unlocked cells. Admin should be able to view/edit all cells on all sheets.
Below is my code which is made for a sample workbook. I was just trying to get the concept down and then i would convert it to the real workbook.
Form Code:
[Code].....
View 2 Replies
View Related
Mar 1, 2009
I have this Excel File which has some sheets. All sheets are the same format like this: "I have read-circled the cells of interest"
I want to have a macro that can read the data from all the sheets (regardless of their name) and from the specific cells "red-circled" and copy and paste them into new sheet named "Report" in table format. Like this:
View 9 Replies
View Related
Jun 27, 2014
I have a macro which creates and names worksheets. I am making a button which also deletes the latest of these created worksheets, but doesn't delete other sheets. I am getting the error: Run-time error '424': Object Required. Here is my code for deleting the sheet:
[Code] .....
MSCount stores the highest "MS#" sheet.
The first line of the IF statement is where the error is.
View 7 Replies
View Related
May 15, 2014
i want to protect my all sheets at once
View 3 Replies
View Related
Sep 25, 2009
I wanted to know if there is a way to lock some sheets in a workbook to prevent anyone to view them. I have a workbook with sheets that have a database, it is shown the frontsheet, and when a person selects an option it will appear a sheet with the data selected initialy. I wanted the other sheet to be hidden and locked so the one goes to the unhide menu and selects a sheet to unhide a msgbox appears to ask a pass code.
View 3 Replies
View Related
Mar 14, 2014
I have a file with the following sheets: P1, P2, P3, Inventory. This file is sent to different people (users Ab, Ad, An) and P1-P3 sheets are set as "VeryHidden" because we want to avoid for example that user "Ab" can see or unhide certain sheets.
I'm wondering if it's possible to request a password when opening the document then unhide certain sheets according with that password, there will be 3-6 users.
View 2 Replies
View Related
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
Oct 6, 2008
See I have hidden my sheets and I need them to stay hidden.
But when I need to unhide them, a password should be needed to unhide them.
Maybe add a button on one of the open sheets that when pressed will unhide the sheets but will promt for password.
View 9 Replies
View Related
Jul 29, 2003
I have a workbook with 7 tabs called "Sat" thro to "Sun". I'd like a macro which
a) protects the sheets as an array (as opposed to individually)
b) preferably uses a password
Using Excel 97 on Windows NT
View 9 Replies
View Related
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
Dec 21, 2006
I have a series of workbooks where multiple users are entering data. Most of the cells are locked, and the worksheets are password protected. From time to time, I have to make global changes to all the workbooks. I've recorded a macro to open all the workbooks, but now, I'm running into a problem because for speed, I'd like to unprotect the worksheets and "re-protect" them without having to enter the password 3 million times (exagerration, but not much). What is the proper syntax of code to have VBA enter the password automatically (it is the same for all sheets).
View 4 Replies
View Related
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
View Related
Jul 12, 2013
I have a spreadsheet with over a hundred tabs, each of which need to be password protected (same password).
I found code on CFO.com that got me half way there. It protects all the spreadsheets, but it does not password protect the macro itself, meaning that anybody can step into the macro and unlock everything at the click of a button.
The code looks like this.
VB:
Sub ProtectAllSheets()
For Each ws In ActiveWorkbook.Worksheets
ws.Protect Password:="secret123"
Next ws
MsgBox "All Worksheets Protected"
[Code] ....
What can I do to prevent people from stepping into the macro, or prompt a password to actually use the macro itself?
View 1 Replies
View Related
Mar 20, 2013
I have a workbook with 6 tabs. The workbook is designed to be shared but I want to password protect the last 4 sheets so that they can only be accessed by certain people. The people who have access need to be able to edit the sheet.
View 8 Replies
View Related
May 13, 2014
I have the following code (provided here some years ago) which works fine. But I now need to modify it to include an optional password and to allow sort of unprotected cells on manually chosen sheets.
[Code] ....
View 5 Replies
View Related
May 18, 2011
Am trying to find the VBA code to "ask a user for the password to unhide multiple sheets/tabs"
I have got the script for unhiding all sheets which is:
Sub Sheets_Unhide()
Dim sh As Worksheet
For Each sh In Worksheets
sh.Visible = True
Next
End Sub
What i would like though is for it to prompt with a password first before the code is executed for unlocking 50 odd sheets.. I know its not 100% fool proof, but would do for what i need!
View 6 Replies
View Related
Mar 18, 2014
I want to hide selected sheets and when i want to unhide them, ask for password to unhide the sheets.
View 10 Replies
View Related
