Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet protection
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
|
|||
|
|||
Worksheet protection
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 | |
|
|
Similar Threads | ||||
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) |