Hi guys, I have a problem with open a workbook. I have an excel file where I have 2 sheets.At both of them I used Protect Sheet.But now I have to open this file with another file that copies some informations there and I get error because the sheets are protected.
I tried this code:
But is working only if that workbook is protected by password,but if sheets are protected,like I want,it doesn`t working anymore.
Any ideas?
Thanks!
I tried this code:
Code:
Workbooks.Open Filename:=ThisPath & "\" & "BazaDeDate" & "\" & "DatabaseLealde2", Password:="admin"
Any ideas?
Thanks!