vba macro open password protected workbook

G

Guest

How do I get a Macro to open a password protected workbook without prompting
the user for it? I have several users writing to the same file via macros but
I want to keep their information private from each other.
 
G

Guest

Just pass the password as an argument the same as you do with the wb path and
name. Something like this:

Workbooks.Open ThisWorkbook.Path & "\gregtest.xls", Password:="greg"

Regards,
Greg
 
G

Guest

If you press F1 on the word 'open', the help system will also tell you about
various other choices, such as update links, and read only. (If the help has
been installed OK!)
 

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

How to Unlock Excel Workbook protected by MACRO Password 6
Setting up Solver reference in a protected VBA project 1
not able to enable macro in password protected .xlsm workbook. 2
workbook open password protected 3
How to bypass password when pasting FROM a protected workbook 3
Macro to open a workbook as read only 2
Excel prompts for VBA password when opening 5
VBA Password - Excel keeps prompting for it 0

Top