Password Box For Spreadsheet Open

Apr 19, 2006

I am just wondering if it is possible to insert a module or a code such that it is user specific.

In detail, there are two types of users: Administrator and User.

If it were administrator, it should ask for a password. If user, it should give the read-only or a protected form of the spreadsheet.

I just need the workbook to pop-up with a msgbox of administrator/user with a radio button or a select button. If administrator, it should ask for a password. Also, disabling the macros should not open the spreadsheet as making this would lead to nothing.

View 3 Replies


ADVERTISEMENT

How To Open Password Locked Spreadsheet

Jun 18, 2013

I inherited a spreadsheet from a recently let go co-worker. This spreadsheet has a lot of important financial data on it, so I really need to get into the spreadsheet. we contacted the former employee and he said he forgot the password. Is there any work around to get into the sheet?

View 2 Replies View Related

Opening My Spreadsheet Which Will Only Open If The Correct Answer/ Password Is Typed

Apr 22, 2009

upon opening my spreadsheet which will only open if the correct answer/ password is typed.

I’d need to store the questions, passwords/ answers somewhere for VB to look up I guess??

Capital of England – London
Capital of France – Paris
Capital of Italy – Rome

Etc etc

And then I need coding which will open one of the random questions, which will only grant access to the spreadsheet if the correct answer is typed.

View 9 Replies View Related

Open Second Spreadsheet Minimized On Open Of Spreadsheet + More

Oct 27, 2009

I have a spreadsheet that on open needs to open a 2nd spreadsheet minimised and delete 2 named sheets in the 2nd spreadsheet.

On close of the first spreadsheet it should then copy 2 sheets with the same name from itself into the 2nd spreadsheet.

This is to start a spreadsheet that will track project risks and issues that I will post further details for as other functions are required.

View 9 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

Spreadsheet Password Protection

Jul 24, 2008

I have a payroll spreadsheet that is going to be placed on our network server. My boss wants me to have this spreadsheet to be protected so that one person can get in, add hours and commission, and save it up on the server. Then another person can go in to that spreadsheet, open it up to get the info and use it to cut the checks. What my problem is that the person who is making the changes does not need to see the pay rate or the total dollar amount columns, but the person who gets the data out does. Neither one of these people really know how to hide and unhide columns in Excel, so I need it to have when one password opens it, the pay rate and total pay columns are hidden, but the other password will show those columns.

View 9 Replies View Related

Userform To Act As A Login With A Password To Use The Spreadsheet

Apr 12, 2007

I have come up with the idea to create a userform to act as a login page for my project. I have the project complete and need a way to protect it. I want the userform to display an input box asking the user to enter their 'login ID'. This has to be either "SUPERVISOR" or "STAFF". Or If I have a table of 'users' and 'passwords' in sheet (USERS) to match them against that if it is easier?

Upon correct entry i need it to then display another input box asking for a 'password'. This needs to be "SHOES" for both logins. If the login is not equal to SUPERVISOR or STAFF I need a message box displaying "username incorrect". and for it then to show the input box requesting the 'login ID' again. Again if the password is not equal to "SHOES" to display a message box displaying "password incorrect" Then show the input box requesting the password. Upon correct entry for both the username and password i would like my other userform to show. This is displayed by:

Load UserForm1
UserForm1.Show

I would like the correct 'username' to be displayed in cell "D27" on the active sheet and 'password' to be displayed in cell "F27" also on the active sheet To show who is 'Logged On'. If there is a way to display the password using asterix's for security that would be useful.

View 6 Replies View Related

Set Password To Open Folder

Jan 9, 2009

A little unrelated to excel as such but helpful to many of us I think. How to set a password to open/ view any folder or directory?

View 2 Replies View Related

VB- Open File With KNOWN Password

Oct 22, 2009

I have a macro that opens Spreadsheet_A, copies the contents to Spreadsheet_Master, closes Spreadsheet_A, then repeats the process for Spreadsheet_B then ss_C then ss_D etc etc etc.....

Each spreadsheet is password protected, and the password is the same for all spreadsheet to stop casual browsing only. I have set the password.

When I run the macro, I have to type the password in each instance, ie 20 or more times for 2 or more files.

Anyone know the code to insert so the spreadsheet opens without my typing the password.

[It's Excel 2007, but I presume the same code as Excel 2003]

View 9 Replies View Related

Disable Password Prompt Upon Opening Spreadsheet

May 29, 2008

have a password protected spreadsheet with a userform for people to enter data. This allows them to enter data, but stops them from editing or deleteing data once entered.

When the spreadsheet is opened, it asks for a password to unlock it. Hitting cancel allows the user to continue and the userform pops up for the user to enter data. I would like to disable the initial password prompt when the file is opened to avoid confusion on the users part.

View 9 Replies View Related

Password Protect/hide The Spreadsheet, Not Forms

May 17, 2007

I am making a database system that tracks student activity in my schools lab for people taking foreign language courses. I'm trying to make it so students must use the userform to manage they're checking in and out, and not be able to have any direct access to the Spreadsheet itself. Also, it would be nice if the whole Spreadsheet was hidden, invisible, and only the user forms could be seen.

View 4 Replies View Related

Online Spreadsheet To Share Between Few Friends With Password Option?

Dec 25, 2004

Is there anywhere I can set up a Online Excel Spreadsheet to share with a few friends with a password option to prevent people from looking at it?

I need everyone in the group to be able to update and save the spreadsheet

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

Unable To Open XLS File Without Password?

Feb 5, 2013

I have a certain .xls file which is password protected.

Now i have forgot the password for opening the file. Is there any other way of opening the file without password or using a Macro.

View 2 Replies View Related

How To Set Password To Link To Open Worksheet

Apr 28, 2014

i have one page with 6 different links, each link will open one worksheet , i want to set password to each link to open there worksheet , i can update my file if it's required .

View 14 Replies View Related

VBA To Open File And Enter Password

Jun 24, 2014

I have the following line of code to open a file and enter the password to allow modifications.

When I run the code the file opens but then the password isn't entered.

View 2 Replies View Related

How To Open Another Workbook That Is Password Protected

Nov 7, 2011

Code:
Sub Open_Test_File()
Dim wb As Workbook
Set wb = Application.Workbooks.Open("DesktopTest File.xls")
End Sub

This very simple little code opens a new workbook.

But if I add a password to the file that I'm going to open the password box appears.

What do I need to add to this code to automatically input this password?

I have tried putting this at the end:

Code:
Password:="123"
but this does not work?

View 2 Replies View Related

VBA Password Forgot - Cannot Open The Code

Jan 17, 2013

I have a sheet which i made ages ago and cant remember my pw. I can goto the alt, F11 select the macro and run it which i have set from all sheets to hide, and i can change the wording on the sheets but i cant open the code.

Does this mean i will have to forget about it unless i remember the pw?

View 1 Replies View Related

Change Open Workbook Password Box

Jul 23, 2006

I need to know weather it is possible to change the "Password protected workbook" box upon file open with a custom user form. I know you can because you can change and disable the "Save As" box etc. I dont mind using the code with a certificate to open the workbook but id prefer not to...

View 9 Replies View Related

Macro To Open Workbook With Password

Jul 25, 2007

I have a workbook with the following

Sub Workbook_Open()
Sheets("Occ-Rent-Concess Worksheet").Select
ActiveSheet.Unprotect Password:="pass"
ActiveSheet.Select
Cells.Locked = True
ActiveSheet.Protect Password:="pass"
pass:
UserName = InputBox("Enter Log On Name to Continue..............................................

This code opens a msgbox that asks for a password and then unlocks certain cells based on what the password is. I have 140 of these workbooks. I need to be able to open them all and change one cell in each file, save it and close. I've gotten the macro written to open, change and save the files, but I am still having to type the 'password' 140 times. Is there a way to bypass it?

View 4 Replies View Related

Password Dialog Box Appearing On Open

Mar 5, 2008

I have not asked for this Dialog Box, but it appears when I open the workbook.

I must have done some strange things - hope someone can give me a hint.

I have attaced a picture of the Dialog Box.

View 9 Replies View Related

Prompte Plugin Password When Open File

Aug 17, 2006

When I opened up the excel file, it prompted me to plugin password. There is no read-only option too. how can i open it up, i tried download some password
protector software to crack it, it is only limited demo which mean can open that file partially not full indeed

View 3 Replies View Related

Open Workbook With Password & Update Links

Sep 28, 2006

I am having a workbook in server, it consists more than 12 sheets. Everyday in the early morning it need to be get updated, (i.e) normally when i open the file, it as for the Password (password for workbook), then after I given it will show three buttons Update Don't Update Help, so i need to press the Update Button , it should be done everyday in the early moring.

Is there any way to do this automatically open and update and close everday through vba code or anyother ways.

View 9 Replies View Related

Excel 2003 :: Removal Of Open Password From File

Dec 5, 2012

How can I remove open password from an excel file having version 2003 without any software.

View 3 Replies View Related

Require Password To Open If Username Does Not Match A List

Aug 8, 2014

I have a spreadsheet (don't we all) that is currently password protected - you double click the file and need to input a password before it will open.

I have some code that will protect a workbook from changes and only unlock for specific usernames, and i wonder if there is some code that will do the following:

-User opens spreadsheet
-VBA looks at the username trying to open the sheet, for this example the username is Paul.Smith
-Paul.Smith is not one of the people who should have regular access to this sheet - so the VBA requests a password from him prior to opening the sheet.

My username opens the same sheet (galvin.paddy), VBA see's that my name is one of the 'Authorised Users', removes the password and opens the sheet for me ready for use.

View 14 Replies View Related

Macro Open Program Type Password Then Enter

Feb 20, 2012

I open a program using code

Code:

Call Shell("C:Program Files...
After this is open i have to type my password, how can i create a macro to open the program as above then type my password then hit enter.

to sum it up

i can open the program

i need code to type in the open program and hit enter.

View 4 Replies View Related

Password Protected Excel File - Can Only Open As Read Only

May 31, 2013

I've got a spreadsheet that has password protection before you can "modify" it. All of a sudden today, when I open the spreadsheet and enter the correct password, it still opens but only as Read Only.

View 3 Replies View Related

Open Secure Website And Paste Username And Password.

Jul 18, 2005

Trying to find a set of code that I can use to open a website that's predetermined, and enter in the users name and password automatically. And if possible, open a new email via the website, addressed to a person, and ready to browse for the file to attach.

The code I have is below.

Private Sub CommandButton1_Click()
'
storenumber = [$c$3]

If [$iv$2] = True Then

If [$iv$3] 0 Then

MsgBox ("Can't send with No Adjustments Checked & Items to Adjust, Please clear one")
End
End If
End If..................

View 9 Replies View Related

Macro To Open Protected Workbooks Prompting To Enter Password?

Jul 25, 2012

I am having an issue with a macro to open password protected workbooks. The macro works just fine in opening the files and whatnot, but for some reason it prompts me to enter the password again once the file has been opened. Funny thing is I can either hit OK or hit Cancel and it goes to the next file. All files open correctly, I was just curious as to why this is happening and how to correct it?

View 1 Replies View Related

Open An Spreadsheet Except Through The Application

Dec 16, 2008

I cannot open an Excel spreadsheet except through the Excel application. This includes through Windows Explorer, on the internet (this forum), in email. I need to save the file first, then open Excel, then open (through Excel) the file.

In Email, I get "System cannnot find the file specified" On this site, I get "Access to the specified device/path is denied" From Explorer, "Cannot find the file.... based on the criteria xls(or one of its components). Make sure the path and file name are correct and that all required libraries are available."

Last time, our IT group couldn't fix it and had to reinstall the entire Office package to get it working again. I'd rather not go through that.

View 2 Replies View Related







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