Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |