password

Hi, I have a few sheets in a workbook, which have macro`s, formula`s. When someone wants to input information they can do in the main sheets, where there are no formula`s, only input information. How can I lock or password protect the sheet or stop keying in the sheet, protecting the cells...

I have several tabs in Excel I need to hide. I know we can using Veryhidden but that can still be unhide without password. I know we can select VBAProject password but that works only if there is VBA code and my file cannot have VBA code for compliance. So any way to achieve my need ? Thanks I...

First, I am not trying to crack any passwords. I am, instead, trying to make sure that a large folder of excels all have been password protected. Obviously, the issue with something like the below is that I have to open the password protected wb to set the variable (which I can't do with a...

Hi, I have the code below to log in to website automatically by getting username, password from cells in a spreadsheet, problem having is that when click and goes to website filled in the password in the box from cell F20 but not in the Login box that should get it from cell E20 (The line in...

Hi, I am looking for below. I want to extract reports from web which is having to username and password. How I can start with? Let me know. Nee

Hi I want to protect a worksheet and allow the end user too use grouping, for which I have the following: Private Sub Workbook_Open() For Each wks In ThisWorkbook.Worksheets(Array("Summary I&E", "Balance Sheet")) With wks .Unprotect "Ronald" .EnableOutlining...

is there a way to once you put a sheet under Hide have it only viewable to admin users. or put a password on that sheet so one other then yourself or selected few can view it?

I just got done creating a couple of password protected files (.xlsm). Works fine when using Excel, but I can open them with LibreCalc and all the worksheets can be unlocked/unhidden without any password protection. Any solutions for this?

ThisWorkbook.Worksheets("jun payroll").Visible = xlSheetVisible I am using the code above which unhides a worksheet when a button is clicked. How do I set it so that a password is required to unhide it? I am new to VBA so if you could write the code in your response that would be a huge...

I have something weird going on with a spreadsheet that I'm working in and given to me by a co-worker to complete. If I open the spreadsheet, it is not password protected. I am able to change column widths, font color, etc UNTIL I enter data in any cell. Once data is entered in a cell, the...

I've pulled an excerpt of coding from my workbook_Open coding. When the wrong password is input into the inputbox, the input box disappears and nothing happens. I have to hit the keyboard (or mouse) to have the "wrong password" msgbox popup. Further, if I click cancel, it doesn't close the...

good morning, I have some code that I've written/compiled for making a "registration key" of sorts for a workbook. Only issue, if the "password, as defined in cell B39, is a series of numbers, the coding works perfectly. if the password is a word or letters, it doesn't. I'm guessing I've got...

Good Morning, I have the following code that's been working well as a "password box" to unlock a few sheets. However, I'd like to tweak it so that the if the password is wrong, it will display an "wrong password" message and then ask for the password again. this is all mounted on userform5 as...

I am working with the newest version of Excel / Office 2019 and am uncertain how to get an older workbook with VBA designed to pull multiple worksheets of data from a password protected site online. In the past, I was able to go to Data>From Web>enter URL and sign in>close window>run Macros>and...