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"...
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...
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...
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...
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 -...
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...
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...
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...
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...
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()...
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...
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 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.