Is it possible for Excel file to be open with 2 password? Like, if password is equal to "Password1" the file can be edited but if password is equal to "Password2" the file will be open as read only, if so, VBA code.
View 1 RepliesI searched the forumn but didn't find thread sorry for creating new thread.
frends i have 2 questions.
1) How to put password for excel file (2003) ? (not for sheet)
2) How to remove password from excel file ? (if its not break forum rule).
How can I remove open password from an excel file having version 2003 without any software.
View 3 Replies View RelatedI'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 RelatedI'm looking for enabling an excel file with a password that prevent it to be copied on an another drive.
View 1 Replies View RelatedI have an excel spreadsheet that I password encrypted in Excel 2003.
The computer that it was stored on has died however the hard drive was still good and has been added as a second drive in my current computer with no signs of data corruption.
I took ownership of all the files on the old drive and gave explicit rights on my current computer to open that file. However when I open the file with in excel. I get the error: You don't have permission to open this file. Contact the file owner or an administrator to obtain permission.
When I open from windows explorer. I get the error: Excel cannot access 'Passwords.xls' The document may be read-only or encrypted.
And: 'Password.xls' cannot be accessed. The file may be corrupted, located on a server that is not responding, or read-only.
The new computer has Excel 2010 instead of 2003. Additionally, I know the password to the encrypted file but it wont let me even get to a place where I need to put in a password. I cannot move or copy this file to another location either.
When opening a new Excel file, it is asking me for a password to an old excel file that was password protected, which I have deleted from my computer. It is still asking for this password every time I open a new or existing file. When I hit cancel it lets me open the file.
View 11 Replies View RelatedI have an existing application that uses DAO sql queries to populate a form. It has always worked fine. Earlier this week, I password protected the spreadsheet. Now my DAO query fails. I get a run-time error '3161'. Could not decrypt file.
' Const stExtens As String = "Excel 8.0;HDR=Yes;"
Const stExtens As String = "Excel 8.0;HDR=Yes;PWD=money16;"
Private Sub Execute_Query(SQL)
'Instantiate the DAO objects.
strDb = ThisWorkbook.FullName
Set DAO_ws = DBEngine.Workspaces(0)
' code fails on the line below
Set DAO_db = DAO_ws.OpenDatabase(strDb, False, True, stExtens)
Set DAO_rs = DAO_db.OpenRecordset(SQL, dbOpenForwardOnly)
End Sub
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]
I tried to research this as much as I could, the thread below is a start but doesnt appear to be close...my request is a bit of a variant to this. I essentially need code that prevents someone from saving the file unless they have the right password.
View 6 Replies View RelatedI 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.
Is there anyway I can remove the password from a corrupt file that I cant access so that I can use Stellar Pheonix Excel Recovery to repair it?
View 8 Replies View RelatedI 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.
I found a function to set the password a an excel file:
=========================================
Function SetPwd(strNoPwdFile As String, _
strPwdFile As String, _
Optional strOpenPwd As String, _
Optional strModPwd As String) ' As Boolean
' This function requires the following arguments:
' strNoPwdFile - The path to a document without a password.
' strPwdFile - The path and name to save the password-
' protected document.
'
But the compiler said that it is syntax error.
How can i rectify the error?
My boss has come to me and asked how does she get her file to go back to the way it was before, she had a password on the file but you used to be able to click on a button that said "Read only" this button no longer appears and i am unable to get it back. I still get the password box pop up but it is smaller and does not contain the read only button.
View 3 Replies View RelatedI have a master file which users are able to open via read only or go in via password to edit.
I'm not too bothered on the read only users more on person's entering the file via password, making any changes and then saving those changes.
Is there a way to trace what changes they made and would their name be saved as the new "author" of the file?
I was able to get some help a while ago and hoping for someone to reply as well. Any one have ideas how to create a userform which will be use for username and password input? I know how to create one but is there anyway that the username and password will be stored as .txt file instead of using worksheet to store the data?
View 14 Replies View RelatedIn wrote a workbook in Excel 2003 that is causing me a problem I can not seem to figure out. The workbook consists of multiple worksheets that work using both VBA code or cell formulas. The worksheets are protected (though w/o a password) to prevent users from accidently altering a cell formula. When the code needs to write to a cell, it first unprotects the sheet, writes to the cell(s), and then reprotects the sheet.
Everything seems to work fine, often for several months. Then somehow something goes wrong. Specifically, after double-clicking on the ListBox in the worksheet “CRI Calculator” to pick a drug name, it will improperly present a dialog box (see attached screen capture 'Unprotect Sheet DialogBox.JPG') prompting the user for a password to unprotect the worksheet. Again, no password has ever been set; I have tried entering nothing, “password”, and "anonymous". Regardless of how you respond, an error code “Run-time error ‘1004’: The password you supplied is not correct…” occurs. If I press Debug, it takes me (ironically) to the following line of code
I have written a macro to select a range of cells one by one and open the excel files mentioned in them and execute a task. It works fine. But I want the system to see if the file exists in its folder or if the file is password protected (for opening). Either of the case the file should be skipped without a warning message and any attempt to open. I need a macro for that. Following is the way the cell contents are
I:ORDERSS-S 10ALIYAMARKET ORDERSADDADD-LADIES-LEGGINGS-13246.xls
I:ORDERSS-S 10ALIYAMARKET ORDERSADDADD-LADIES-PANTS-13247.xls
I:ORDERSS-S 10ALIYAMARKET ORDERSADDADD-LADIES-SHORTS-13244.xls
I:ORDERSS-S 10MICHELLEGAMESWORLDWIDE COMPANYWORLDWIDE COMPANY - GAMES - 10014.xls
And following is the VBA code I wrote. It it almost stops when reaching a non-existing file name
I have a master file that generates a new file every time the master user run the macro. The macro is pasted here:
Code:
Sub NewWorkbook()
'
ThisWorkbook.Unprotect ("Password01#")
[Code]....
I want the new file to be opening without asking for any password at all. What am I supposed to include in the code for that?
1. In centain directory I have xls files where name of each file starts from "HR" string, eg. "HG_Control Mike.xls", ora "HR_Control Mark.xls".
2. I have a master xls file where I want to start a macro that will open each of xls "HR" files and copy selected rows to this master xls workbook (need to write this one too).
Problem is that opening of every "HR" files suposed to be protected by password. Users will be adding new xls "HR" files to the directory so I will not be able to change macro everytime new xls is added. So, I need to make a macro that will generate password base on xls "HR" file name and then I will use this password to protect this files and open them by another macro.
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
how to create and add password to a default windows zip file using vba excel macro.
View 2 Replies View RelatedI 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.
VBA coding for automatically saving an excel file as another file using the current date as part of the file name together with "32ga" as a constant add-in. I also what this macro to run at a particular time of the day let say 00:20hrs. The excel file i want to save as is always open . It has data that changes every 24-hrs.
View 1 Replies View Relatedi want to know how to recover the password for excel?
View 2 Replies View RelatedWe had an Excel worksheet that is used everyday suddenly pop up with protection. I have used protection before, but this one never had a password. We put in every known password we use, but none worked. I resigned to re-typing the worksheet, then, in between Friday night, and Saturday noon, when most of the office is out, a different Excel worksheet has the same problem. We are using Excel 97.
View 3 Replies View RelatedIs there a way to protect the excel sheet with a password that expires after a particular time.
View 1 Replies View RelatedI'm password protecting a workbook. But I found this:
[URL] ........
Which I've tested and works to break the password.
Is there a way to "super" protect a workbook and worksheets from having the password broken?
I have an MS Excel 2010 xlms file which is password protected. Unfortunately, the person who has the password has left the company!
Which is the best tool to remove the password / recover the file?