password protection

  1. B

    Need to have many passwords for same excels and used to enter data and accept data.

    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...
  2. A

    Check if file is password protected

    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...
  3. M

    tracking bad paswords

    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...
  4. P

    Password Protected worksheet and workbood does not prompt for 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...
  5. S

    Auto Open A Protected Workbook

    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...
  6. C

    Unhide Rows In a Protected Spreadsheet

    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...
  7. T

    Excel suddenly asking for workbook encryption password 2X after it has been opened

    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...
  8. C

    Force a Password Change every XX days

    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...
  9. S

    Password Protection of Excel-based Software to Unique Users

    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...
  10. 4

    Workbook password and a delection of the entire workbook time sensitive with a specific date.

    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...
  11. B

    Protected Sheet Hacked

    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...
  12. I

    Hidden Columns Appearing on Smart Phones

    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...
  13. J

    EXCEL VBA: How to set a password to another VBProject programmaticaly

    <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...
  14. L

    Time Limit on Workbook Password Protection

    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?
  15. S

    Unprotect workbook, allow repeat password

    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"...
  16. E

    Password protection in Excel 2013 any good for securing formulae etc?

    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...
  17. Z

    Unlocking Locked Workbook

    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...
  18. H

    Cannot change protection password

    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...
  19. G

    Protecting Workbook and its Contents

    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...
  20. Gingertrees

    Data validation not working - why?

    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've detected that you are using an adblocker.

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.
Go back
Back
Top