| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unprotect a Excel workbook using vba macro
Is there any way, I can unprotect a excel workbook using vba macro.
Thanx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unprotect a Excel workbook using vba macro
Activeworkbook.unprotect "MyPassword"
HTH "VJ" wrote: Is there any way, I can unprotect a excel workbook using vba macro. Thanx |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unprotect a Excel workbook using vba macro
Hi Jim,
I am sorry, It is about locking and unlocking a workbook using vba macro. Thanks for ur help "Jim Thomlinson" wrote: Activeworkbook.unprotect "MyPassword" HTH "VJ" wrote: Is there any way, I can unprotect a excel workbook using vba macro. Thanx |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unprotect a Excel workbook using vba macro
'If document is protected, Unprotect it.
If ActiveDocument.ProtectionType < wdNoProtection Then ActiveDocument.Unprotect Password:="" End If 'ReProtect the document. If ActiveDocument.ProtectionType = wdNoProtection Then ActiveDocument.Protect Type:=wdAllowOnlyFormFields, _ NoReset:=True End If One unprotects then one protects "VJ" wrote: Is there any way, I can unprotect a excel workbook using vba macro. Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot unprotect workbook with an Excel crash | Excel Discussion (Misc queries) | |||
| Unprotect workbook/worksheet Excel 2007 | Excel Discussion (Misc queries) | |||
| I've forgotten the password to unprotect a workbook in Excel. | Excel Worksheet Functions | |||
| How to unprotect a workbook by macro? | Excel Discussion (Misc queries) | |||
| Macro to unprotect workbook | Excel Programming | |||
Linear Mode
