password

  1. S

    How to hide VBA Code on a Protected Sheet?

    I am using code to add a double line that requires me to set the same password as the password to protect the sheet. And I don't want someone to be able to view the code on my protected sheet. How do I do this? Also, I don't want to hide the sheet, just protect it. Here is the code, if needed...
  2. L

    Password Protect Tabs (or only able to view a certain tab)

    Hello all! New user to Excel (previously Google Sheets). First of all, I have tried to check other posts that are similar and google, but don't think I have found exactly what I am looking for as each seem different. I currently have a spreadsheet to review Pay Rises, Overtime etc. I have...
  3. C

    Excel VBA - Split files and password protect

    Hi all, I have some code which allows me to split a workbook into multiple based upon a specific column. The code currently is dynamic in the sense that it asks the user to define the column number (Col A = 1, Col B = 2, Col C = 3, etc.) and define the row where the data begins. The names of...
  4. M

    How to manage ODBC connections

    Hello everyone, I have an Excel application (like an end user computing app) used by employees to communicate with a remote database through ODBC calls. The ConnectionString use a generic account and a password stored in a third-party file, when users open the Excel tool the connection is...
  5. A

    My codes to open password protected workbook doesn't work

    Hi everyone, Below is my codes. It does try to open the file, but it keeps asking me for password although I already include the password in the codes. What have I got wrong? Sub openfile() Dim wb As Workbook Set wb = Workbooks.Open(FileName:="C:\...", Password:="password") End Sub...
  6. R

    Help on how to block unauthorized distribution of excel sheet

    Hi Guys :) I'll explain my problem to better understand, so you can recommend the best approach to fix this problem. Sometimes a I deal with the sale of some analysis excel files that I created. What I need is a method to keep them from being spread or shared by customers, as many represent...
  7. B

    Macro to unlock and lock file

    Hello, I'm trying to create a macro that will unlock and lock a source file saved in a different folder from the file I'm running the macro. It keeps giving me an error and I'm not sure what's referring to. The error says: "<Method 'Range of object'_Global' failed>". Please see screenshot...
  8. C

    Password Protect?

    Hi everyone :), Is it possible to save my workbook on to the organizations network so that anyone may access it for viewing purposes only? But i want to be the only one who can go in and make changes. All help is greatly appreciated, I am going into excel right now with very little to no...
  9. F

    Referencing a password protected sheet while keeping the password secret

    I have a workbook that will sit in a folder that anyone in the company can access and which needs to be modified by supervisors, let's call it ProductionWB. Management is able to pull a report from our timecard system that has everyone's raw data in it, let's call it TimecardWB. I need to have...
  10. A

    VBA hiding passwords in code

    I have a hard coded password in my macro, but I don't want it to be visible if someone chooses to go look at my code. Is there a way to have it hard coded and hidden from view?
  11. Jaafar Tribak

    Lock-UnLock VBAProjects Programmatically without SendKeys

    Hi all, I Have recently written this piece of code so I just thought I would post it here for future reference should anyone be looking for vba code to lock\unlock a vbaproject programmatically without needing to use the unreliable SendKeys method. workbook example This code requires that the...
  12. G

    General Question. Is there a way to distribute (sell) an Excel File but protect the contents from being hacked, copied?

    I enjoy writing Code for Excel files. Is there any way I can ever sell an Excel file and protect it so that it can't just be copied and distributed freely to anyone who wants it?
  13. E

    On error try different password VBA

    I have a piece of VBA code that opens a workbook that is password encrypted, but could be one of three different passwords: Workbooks.Open Filename:="\\Drive1\Folder1\test.xlsx", Password:="Test1" Workbooks.Open Filename:="\\Drive1\Folder1\test.xlsx", Password:="Test2" Workbooks.Open...
  14. S

    Temporarily unlock VBAProject password to run code

    Hi Experts, I have a number of workbooks (20+) that are being used by multiple users, and the code is password protected in order to hide sensitive information. Currently, I'm working on implementing a UserForm, that will be the same for all workbooks. The form is be imported on open, and that...
  15. P

    Workbooks.Open in VBA - Getting Password Popup Window

    I have the below code, which I will use to open a file. I will then gather data about the file and report back in a master workbook. My issue comes when I am trying to open a file which has a password: The first Workbooks.Open method presents me with a pop-up window, which I expect, although I...
  16. I

    Password a folder

    Morning. I have some zipped files that I need to keep for future reference. I wish to keep them in a folder on my pc & this is for my web site. I don’t wish to use google drive etc. Can the folder be password protected ?
  17. S

    Refresh pivot table external data with encrypted password

    I have 10 excel files that contain a table with many columns and many rows and that need to be updated frequently with new data. In order to have a faster record of some data from these files, I created a separate excel file that centralizes them all 10 files by external pivot table data and...
  18. O

    error message

    i kept getting this message whenever i try to unprotect one of the sheets i was working in excel today. it said this "the password you supplied is not correct. verify that the caps lock key is off and be sure to use the correct capitalization"....but the password i encrypted on are NUMBERS! does...
  19. C

    Pull data from multiple password protected workbooks

    Hello again - I have several individual password protected workbooks - one for each employee, each with a unique password - that collect that employees timekeeping data. I'm trying to make a master sheet that will pull data from each of these individual files into one master file for me (the...
  20. N

    Password Protecting Worksheet from Viewing or Alternatives

    Is it possible to have multiple people share the same workbook with different permissions? Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab? OR If you create the spreadsheet tabs to be very hidden, is it possible that the person who...

Watch MrExcel Video

This Week's Hot Topics

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
Top