Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect VBA Project By Macro
Hi all, I am looking for macro with which i can password protect
other Workbooks VBA Projects. I know you can do it by sendkeys but can please anyone know what will be the full macro code if i want to protect VBA Project of some other Workbook. Like if i click button from Workbook A then it should protect VBA Project of Workbook B. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect VBA Project By Macro
you could try the following:
so when you click button from workbook A.... Workbooks.Open Filename:= "C:\workbookB.xls" ActiveWorkbook.Protect Structu=True, Windows:=False ActiveWorkbook.Save ActiveWindow.Close |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Excel VBA Project from another Excel Macro | Excel Programming | |||
protect / unprotect VBA project by macro | Excel Discussion (Misc queries) | |||
Protect current VBA Project? | Excel Programming | |||
protect/unprotect a VBA Project | Excel Programming | |||
protect/unprotect a VBA Project | Excel Programming |