password macro

  1. U

    VBA Remove Password on Word Documents

    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"...
  2. U

    VBA - Delete Password and Save without Password

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

    VBA Store Password

    Hello. I am done with a financial model and the end user will start using it. To access the file, I have an input box where he can enter his credentials (username and password) which are preset by myself. Is there a way to have a "Change Password" button where he can change the password and...
  4. C

    Runtime error only when using keyboard command for macro

    Hi, I've made a spreadsheet that compiles data from 8 separate spreadsheets with 8 different passwords. It's the same group of people using all of them and it's a pain to type in 9 passwords - including the compilation one. The thing is, the macro works fine if you run it manually - View/Macros...
  5. J

    Userform indexing, combo box and back door password protection for displaying of a Dashboard

    Ok, I've been slaving over this problem and even after 2 days of trying I only feel close by 20% if that. Goal: Create a dashboard with personnel's training information that they can print or click on hyperlinks (embeded) to specific course sites. This dashboard - snapshot as I am calling it -...
  6. L

    Password generator

    So, I'm trying to create a random 15 digit password with certain criteria. At least 3 of the following; uppercase, lowercase, special characters, numbers. I also want to make each character unique, I have 2 formulas: 1...
  7. S

    VBA to unhide a very hidden tab and then hide current tab

    Hi, I have a code that I use to launch an input box, when the correct password is entered it unlocks a specific tab, that was previously VeryHidden. I'd like to modify it so it also hides the current sheet when the answer is correct. When I try to modify, I end up hiding the active sheet...
  8. A

    VBA Set password to modify on closing

    I want to have a prompt box to pop up when closing a workbook to enter a password that sets the password to modify the workbook. I can get it to work if there is no password set, but once the password is already set it will not allow me to change it. Is this possible? Thanks in advance. Sub...
  9. R

    The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization

    I can protect and unprotect sheet using VBA but I can't unprotect using the normal way of excel and I am providing the same password. any help please? below are the codes Sheets("sheet1").Select ActiveSheet.Unprotect Password = "protect20" Sheets("sheet1").Select ActiveSheet.protect...
  10. A

    Password protect macro at certain time period

    Can I password protect the below macro to run between 8.30am and 6pm? with a message like "Please enter password to refresh the pivot tables between 8.30am and 6.00pm" But however the I need macro to run without the need of the password between 6.01pm and 8.29am. Sub AllSheetsRefresh()...
  11. R

    Password Protect Macro From Running

    Hi, I know it's possible to password protect Macros from viewing / editing the code, but is it possible to password protect them from running? I've got two macros assigned to buttons, one to Protect all worksheets with a password, the other to unprotect them, with the password... But I'd like...
  12. A

    Secure / Protect Your Macro

    Hello, I search the forum but can't find a thread which informs how we can secure our macros. Maybe it is so easy but I am a newbie :) Is there an option in excel developer section or a code that can protect my macros to be taken from anyone or can I set a master password to "Step into" macros...

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