1. 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...
  2. 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?
  3. 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...
  4. 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?
  5. 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...
  6. 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...
  7. 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...
  8. 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 ?
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. K

    Macro to unprotect a password protected sheet

    My old computer had a macro, I unsuccessfully tried to re-create it on my new computer. My Excel worksheets are protected with a long password, I want to unprotect it with a simple macro that contains the password. When I record the macro, it doesn't capture the password. What am I doing...
  14. G

    SaveASUI doesn't work as it's being called by another macro

    Hi all, I have a file that my users are not permitted to save, but I want my staff to be able to modify and save. I have an old macro from mikerikson which works if my team or I wants to save this master file and enters the appropriate password, thus: Private Sub Workbook_BeforeSave(ByVal...
  15. B

    VBA Autoprotect sheet and allow filtering

    Hi, I have created a macro that will autoprotect and sutosave a sheet when closing with a specific password. How I need to allow people who do not know the password to filter on the sheet. what code do I need to add to allow filtering without being able to unprotect the sheet? Code I...
  16. A

    Error message: "expected named parameter" when using AllowFiltering:=True

    Hi, I'm a bit of a novice when VBA and have tried a macro that removes a password from a locked excel sheet, does an action and locks the sheet again with the password. I seem to be unable to enable filtering and sorting, getting the error message "expected named parameter". Is anyone able to...
  17. H

    Download data from website that requires login id and password

    I want to do a macro (hopefully record macro) and need to extract data from a website that requires a password. However, my colleagues have their own login ID and password, and i do not want to share my login ID and password with them. What should I do such that i can retrieve data from the...
  18. P

    How to protect a workbook in windows

    I know how to protect a worksheet in a macro and also protect a workbook in a macro. But I don't know if it is possible to protect a workbook in windows. Let me explain. When I open up say drive F:\... on my flashcard, I see my workbook which I will call book1.xlsm. I want to be the only...
  19. Z

    Restrict Print Until Some Conditions are made

    Good Afternoon Mates! I want to make an excel sheet which will not allow the user to take print until the the latest changes are saved. Actually I have created a file which requires "password to modify". Without entering the password, one can access the file with "Read Only" mode. But, in read...
  20. Z

    Do I need any macro to set sheet veryhidden?

    Hi, I want to set one of my sheet to be non visible. I have set its properities to xlsheetveryhidden, but project protection by password does not work. It will be enough when I add any (even blank) sub inside?

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...