password protected

  1. B

    VBA Code to Protect/Un-Protect Sheets asking for a password when there isn't one

    Hello Everyone, I wrote some code to protect/unprotect all of the worksheets in my workbook, and when I run the code in the vba editor it works perfectly fine. However, I added some shapes to my excel file and then assign the macros to those shapes, so the macro could be run at the click of a...
  2. 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"...
  3. 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...
  4. L

    Copy & Paste for Password Protected Sheet Is Not Working

    I am working with a password protected sheet that has hidden columns. I used to be able to select all (Ctrl + A) and then copy a whole sheet, then go to a blank sheet & paste and then be able to see all the columns, including the hidden ones. Recently I found that I'm not able to do that...
  5. S

    VBA for password protected PDF file

    Dear group members, I am trying to write a VBA code for opening password protected multiple PDF files (password known to me) one by one and copy the data in excel. I am not able to do so. I tried to google out. I have the code from which you can open the normal pdf file. Can you please share...
  6. S

    Use VBA to Open a Password-Protected File

    I am trying to use a macro to consolidate data from protected workbooks. Note: It appears PowerQuery doesn't like password-protected files. Below is the vba I have used to open unprotected files in the past. How do I modify the script to provide the required password. [CODE]Workbooks.Open...
  7. FalconBLUE

    Connect to Protected 2007 MS Access Database mdb file

    Hi everyone, I have userform and transferring some data to closed excel files. This data collecting in MS Access mdb database and I want to protect this. I found a string from the net and I connect unprotected my mdb file successful. These codes are below but I don't know how can I connect my...
  8. C

    Autoexpand Row Height on a Password Protected Spreadsheet

    Morning All, I am using Excel 2010 which I am experiencing a small problem with. I have a spreadsheet which is password protected, this spreadsheet contains a large number of formulae lifting data from another spreadsheet. When I make a selection from cell O2 I would like rows X5:Y11 to...
  9. A

    VBA to Paste data into Access table

    I need to copy data from a username/password protected "homegrown" database (that can be a little slow) and paste it into an Access Table. I wrote a macro in our "homegrown" database that I linked to `. I'm able to do the following in Access: Sub AutoExec() AppActivate "Session 1" delay...
  10. A

    VBA- Automate web query on password protected site

    Hi all! I have access to a website that contains data on companies with a download to excel option. You search an id number or the company name in the site and then you can choose the data points you want and export to excel. Now I have 10s of thousands of these id numbers and am looking to...
  11. R

    VBScript to open a password protected file in order to edit links.

    I have a working program but want to add a password to the external file I'm using to update my active spreadsheet file. I do not want to be prompted for the password when I initiate the "update" command from within code. I would like to automatically pass the password through scripting. Here is...
  12. N

    Master Workbook or Master Password to access a workbook with multiple password protected worksheets

    My company has an Excel workbook with a "Menu" worksheet with linked buttons to individual password protected worksheets for varying individuals. Management wants to be able to open this file without having to type in the 15 some odd individual passwords each time. I've been tasked with figuring...
  13. J

    VBA - issues with pulling source data from password protected workbook

    I'm using VBA to pull a large amount of data from a closed workbook that's password protected. While the code that I've put in works smoothly, there are 2 annoying issues that remain that I'd like to get rid of, which I suspect may be related. 1) I have to enter the password twice - once when...
  14. E

    Excel VBA, Hide/Unhide worksheets, Password protected file...

    Hi there, I have an Excel file with a macro to unhide certain worksheets when the user clicks a button. I also have a "control table" worksheet hidden in the file that I do NOT want users to access. My dilemma is -- if I password-protect the structure of the workbook to prevent users from...
  15. melodramatic

    I want the file to open Read Only WITHOUT prompt

    I have a macro that opens up a file of forms, makes customizations, and saves each worksheet in that file as it's own form in the new project. It works great (self pat on the back here), EXCEPT that I have users complain that they have to hit the Read-Only button. Obviously, having to wait the...
  16. L

    Open Excel Workbook from Excel and Access 2003-2010

    Hi All I have been trying various codes to open a selection of one Page workbooks (Graphs) from Both Access and other Workbooks. Access is being used mainly as login and navigation to reports. The below code is the best I have so far, but when opening form Access 2003 , I still get password...
  17. A

    Password Protect multiple Workbooks via VBA

    Hi, Is it possible to have an Excel file which will list Folders and Excel files within those folders and have VBA assign passwords to those files? Folder C:\Data\Test File Name Test.xlsx "Password" Test1.xlsx "Password1" Folder C:\Data\Test1 File Name Test.xlsx "Password" Test1.xlsx...
  18. V

    Running VBA codes while worksheets are protected.

    Hi, I have a workbook where each individual worksheet is password protected. Many of the codes involved are hiding row and columns and I want the code to be able to run, but I don't want the individual to be able to unhide columns/rows without the password. Is there a way to do this.
  19. J

    How do I stop a Input Box Loop for a Password when user clicks cancel?

    Hi guys, So my workbook is protected. I need a macro which prompts a InputBox saying "Please Enter Password." If the password is incorrect, it says, "Incorrect password. Please try again." and loops to the first input box. However... if they hit cancel, I want it to shut off the document...
  20. B

    VBA to enter password when prompted

    Hi all, I have a looping code to open workbooks and copy then paste data to another workbook. Each workbook I open has a password. They are all the same password, how do I get it to enter automatically? Here is my code so far Sub OpenAndClearContentsInColumnAA() Dim strF As String...

Some videos you may like

This Week's Hot Topics

Top