Open Locked/Protected workbook using vba

V

VJ

Hi,

Is there anyway to open a locked or protect workbook through another
workbook using VBA macro?

Thanks and regards,
 
D

Dave Peterson

You could provide the password in the workbooks.open statement. Do you know it?

Look at VBA's help for more info.
 

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 VBA 0
Running Macros in a Shared File 2
VBA Debug Issue 2
Programmaticlly sign and password protect a VBA Project in Excel 2 6
How to bypass password when pasting FROM a protected workbook 3
Lock single Module ONLY in workbook; without locking VBA project? 3
Allow VBA code to change a locked cell?? 2
Pulling data from one workbook to another one using VBA 0

Top