Accessing password-protected Excel wkbk from VB

  • Thread starter Thread starter shawshank247
  • Start date Start date
S

shawshank247

I want to password protect a workbook so that no one can open i
directly w/o a password, yet want to be able to access the data from V
w/o having to type in the password during runtime
 
You can specify the password in the Workbook's Open method. This way,
you type the password at design time.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
How to Unlock Excel Workbook protected by MACRO Password 6
Excel 2007: Macros not working in password-protected workbooks 2
How to bypass password when pasting FROM a protected workbook 3
Are password protected WiFi networks secure? 3
workbook open password protected 3
Exporting data with vba from Excel to an Access 2007 db with password 8
password protect individual sheets 1

Back
Top