Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am working with a group of files that unfortunately were protected. Is
there a way in Windows Explorer that I can unprotect all the files in a directory without having to open each file individually and select the unprotect option. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
See if this macro does the job:
Sub BatchUnprotect() Dim myFile myFile = Dir("C:\Data\*.xls") While myFile < "" Workbooks.Open myFile Workbooks(myFile).Unprotect Workbooks(myFile).Close myFile = Dir Wend End Sub HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet protection status | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) |