password to open

  1. B

    Password to Open workbook : automation

    Hi all I'm very lost and looking for advice. I have several workbooks that are password protected - meaning I have to enter a password just to open them. The password is simple, "abc". I get frustrated with opening spreadsheets then having to divert myself to the keyboard to type. Is there any...
  2. R

    VBA - Verify "Open password"

    Hello guys, before I get misunderstood I'll make it clear. This is not a thread about hacking/cracking Excel/VBA passwords, the situation follows: I have a project in Excel and it contains some sensitive data, it's not top secret but I'd like to avoid anyone beeing able to open the file and...
  3. D

    activate worksheet with single password entry

    Hi Everyone...I'm a newbie here. Desired Scenario, 1. User opens spreadsheet. 2. Spreadsheet has two worksheets 3. User selects to view "Sheet2". 4. User is prompted for password (once for the entire file session). 5. Correct password (softball) allows access to worksheet, incorrect password...
  4. K

    Set File Property of File With Password

    Hi, I have an Excel Tool that opens several spreadsheets in several folders and adds comments in the file's properties (looping via InputWB.BuiltinDocumentProperties.Item ("Comments")). The problem is, whenever I encounter files with Password To Open or Password To Modify. Right now, I...

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