unprotect 1500 files

**nadiminti** · 02-27-2013, 01:14 PM

Hi

I have a unique problem of unprotecting 1500 files daily. We send the files with a protection and receive them after getting updates from the team.

Earlier, we used to send the files unprotected and after receiving, I use a method of merging all of them after storing in a single directory and do the processing on single file.

Now with Protection password set by me and sent across to the team, the merging fails with an error indicating that the sheet is protected and fails.

As we are setting the password and know the password, we can unprotect manually - but time consuming and laborious. Can any one help?

Thanks
nadiminti

**TMS** · 02-27-2013, 01:20 PM

use Sheets(".. whatever ..").Unprotect Password:="whatever"
and Sheets(".. whatever ..").Protect Password:="whatever"

before and after your merge code, respectively.

Regards, TMS

**nadiminti** · 03-01-2013, 02:51 AM

Thanks Trevor - worked like a well-oiled engine. Great help...

**arlu1201** · 03-01-2013, 03:21 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.