View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sameoldcalvin sameoldcalvin is offline
external usenet poster
 
Posts: 9
Default 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