| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2007 VBA not recognizing .ProtectContents properly
2003/2007
Below is a VBA snippet that worked fine in 2003. With 2007, the code below does not consistently sensing if wks.ProtectContents = True, therefore, wks.Unprotect Password:="12345678" is bypassed. Any thoughts or workarounds? EagleOne For Each wks In MyPreviousWorkBook.Worksheets wks.Activate If wks.ProtectContents = True Then wks.Unprotect Password:="12345678" End If Next wks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PAGE PREVIEW NOT WORKING PROPERLY IN EXCEL 2007 | Excel Worksheet Functions | |||
| Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
| Vlookup not recognizing field | Excel Worksheet Functions | |||
| Recognizing #N/A | Excel Worksheet Functions | |||
| Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
Hybrid Mode
