One person should enter the data with his password, and his name should come in "issued by" and other person should accept the data with his password and his name should come in "accepted by". Till he accepts, it has to be in different colour. if he rejects it, the data shouldnt disappear, it...
Hi everyone! I'm looking for a way to check if an Excel file is password protected. If so, VBA should open it with the "default" office password. This should happen anytime a file is opened by any means (i.e. from Windows Explorer, and not just through another piece of code in another Excel)
I...
So i have a lot of password protected macro buttons in my project and I am tracking the user name of anyone who enters the correct password on a hidden sheet called "users" its kind of a built in audit trail . I would also like to capture the user names of people who enter a bad password...
Hi
I password protect several sheets and the workbook in an Excel file before passing it on to my clients. When I get it back with their edits, the sheets and workbook are still protected, but clicking "unprotect" unprotects them without asking me for the password.My clients are not computer...
Hi,
I have workbook which needs to be password protected.
When staff open the work book they are presented with a form to complete and upon saving, their answers are saved to a sheet and the file closes.
I have password protected the workbook to stop staff opening the workbook, and making...
Hi,
I have found the following code on the Internet which has allowed me to protect all the formulae in a Workbook, however, I need to be able to unhide any column or row to view without removing the password protection. Could someone, please help me modify the code below to allow this for me...
I have a password encrypted workbook that I have been working with for several months now. All of the sudden in the past several days, once I enter the password to open it, it requests the password twice more. I can cancel both requests and begin working in the file with no issues. It's just...
I've been using MrExcel for years but always found what I needed and never had a need to post before.
I was hoping someone could help me with a strange request:
Does anyone know of a method of have the code that I could use to force a user to change the workbook Password every 90 days? and...
So, I've developed a small piece of Excel-based software that I'm thinking would benefit from some sort of password protection. Basically, I aim to sell the software in some form but I would like to at least try to limit piracy on some level. I'm not a huge VBA-user but I'm not exactly...
I am looking to protect my written program in mircosoft office excel 2013/365.
I am allowing others to use my program for a given time frame, but I want to protect my interest in the program I have written. I want to allow a user to use my program for a limited time frame only.
I already...
I have a program that depends on VBA and cell formulas that I send to customers for projections. We do not want them to have access to either the formulas or the VBA. I feel the VBA is safe (enough) with password protection.
However, even with sheet protection, one of our customers sent back a...
Hello Everyone!
OK, I'm stumped. I have been generating and emailing password protected spreadsheets for years, hiding rows and columns that I don't necessarily want shared with everyone, with no trouble at all. Then all of a sudden, a few months ago I get word that hidden columns on one of my...
<tbody>
I have created a vba code that creates a new .xlms file, adding some code to that file and then my problem is that i cannot protect the VBPoject of that new file. Instead, i wrongly password protect the current VBProject (not the new...
Is there an easy way to time-Limit password protection of a Workbook?
The obvious option is to write VB code that Auto-executes and causes the password to change after a specified period. Are there alternative ways to accomplish the objective?
In one of my macros, I unprotect a shared workbook. I haven't programmed the password into the code. I admit, mainly because I was having problems with it, and decided that entering it manually wasn't such huge deal LOL. The line of code I'm using is simple "ActiveWorkbook.UnprotectSharing"...
After a few searches I couldn't find anything up to date on how secure password protection is on Excel 2013.
I've read in these forums and elsewhere that password encryption is now stronger in Excel 2013. I was wondering whether anyone has a view as to whether excel 2013 password protection can...
Hi,
I created a debtors reporting system at work to be used by several users across the company (probably about 30 people) and saved it on the shared work network. I locked each sheet individually and left certain cells unlocked with data validation set up for those cells. The purpose of...
Hi all-
I have a spreadsheet that was given to me, which I used as a template. It already had password protection in it for each worksheet, and the macros are also written to unprotect before performing the actions, the re-protect at the end. Everything works fine except I cannot change the...
Hello, I am continually running into an issue when trying to protect my workbook with macro's
I have a workbook with 12 sheets.
Upon workbook_open, I hide them all, except the first which is protected completely, no one can even click on a cell. At the end of the code, I protect the workbook...
Summary: Excel 2010, password-protected workbook with data validation in cells, that is not doing its job of rejecting non-compliant entries.
I've created numerous protected workbooks for use by less-than-computer savvy users, who fill them out and email them back to me. I protect the heck out...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.