password

The following code worked fine until some of the computers were upgraded to Windows 10 from Windows 7. The upgraded computers work fine except for this code. The textbox appears and the correct password is entered... then they get "The password was wrong, try again." WHY!!!!!???? I do not...

Hi all. I have a userform that allows me to type in a username and a password. This then is checked to a hidden sheet and if found it opens if not it returns an error as per bellow code; Private Sub cmBtnLogin_Click() Dim iFoundPass As Integer On Error Resume Next With...

I'm wondering if anyone can help me consolidate this. I have 59 checkboxes on a worksheet. They are all ActiveX controls that run the following code. Each is unique. The purpose is if the box is unchecked, it unlocks the sheet, and changes the Locked property of an adjacent cell to Unlocked. If...

Hi All Board members, Can any one please provide me code.. the excel file which i will share today with someone..should not open that workbook without password.. Pls assist..

I have copied the Excel online file link and paste and it says do not have Access. The first time it ask me to supply Organization Account password and I carelessly cancelled and now that prompt never appear again. I have the organizational Account password. What can I do ? Now it does not ask...

I try to compare two Excel files in Excel 2016 by using INQUIRE/Compare files ribbon buttons but can't get further then opening. I get a pretty scary message "Retrieving the COM class factory for component with CLSIF {00024500...} failed due to the following error> 80080005 server execution...

Hello I want if there is a change in price it should reflect in new records only but should not disturb the previous records with old prices. a link of my file in the drop box is given below. https://www.dropbox.com/s/uq3fyn1snj1ah5y/salarzai%20petroleum.xlsm?dl=0 Password for opening/...

Hey Guys, I have some 200 excel workbooks with password protected. Whenever i/my team wanna open this workbook need to be given the password, Is it possible to give some windows/User authentication for those specific excel sheet to bypass the password protection ? Dinesh S

Hi, i have the following which loads a webpage and extracts the JSON Sub JSON1() Dim username As String, password As String username = "xxx" password = "xxx" Dim xmlhttp As Object, myurl As String Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") myurl = Range("C1")...

Hi Guys, I'm using below codes to remove password and save excel files without password. Can you help me modify the codes so I can use this for word files? =================== Sub RemovePassword() Dim xlBook As Workbook Dim strFilename As String Const fPath As String = "C:\My Folder"...

I am new bee here hoping to get some solution. I am looking for a tool to capture the volume processed by the team on daily basis. I tried to create it by own but couldn’t finish it… Could you please help me on this.. User name : Abhi Password: 123...

Hi Guys, I'm trying to open and save the files without password using below codes. However after running the codes, I tried opening one file and the password is still there. Is there any way to: 1) After inputting the password, save the files without password 2) Can you help me modify below...

I have lock certain cells in my workbook and added a password to it. I am looking for a way to disable the initial password prompt command for when another user opens the file. Thanks

Hi everyone. Seven years ago I wrote a large workbook as a favour for a friend. I protected a lot of cells to avoid accidental corruption. He has just come back to me and asked for some changes. I gave him the password but as hes never needed it he's forgotten it and my email storage doesn't go...

Hi, I have written simple date check on open in one of my files, that prompts for password when it is expired and want to add wrong password counter and will add some more code to it on lets say 3 wrong attempts, but can not manage it to work. Private Sub Workbook_Open() Dim pass As Variant...

Hi everybody I have generator password in excel, but sometime, my password have dulicated character, which make my password less secure, can any one help me with the fuction to help my password not have a dulicated character. My password is in G1, the ingredient to make my password is from D5 to...

Good day all. I have a spreadsheet with 80 (and growing) tabs. When this file is distributed, I would like all tabs to be protected with a password. I have VBA which does this: Dim wSheet As Worksheet Dim Pwd As String Pwd = InputBox("Enter your password to...

So I am trying to password protect my workbook so that it won't open unless you have the password. But here's what i need: I need to have a cell that contains the password so that it can be changed whenever and easily for someone who has no excel or computer literacy, without going through...

Hi, I have two worksheets, named as A and B. I would like to assign two different password to A and B. And if the user input A's password, the worksheet A will be shown.. and same for worksheet B. Some cell values in B is referring to A, thus, I would like to make sure B also displays the value...

Hi, It is possible to write a macro, for closing password protected excel file, on wrong password entry and no-entry for 10 seconds. regards Metin