Run Macro in protected Workbook

Question

I'm using Ms. Excel 2007. I can't run my macro when my workbook structure is protected. Is there anyway i can do to do run macro while my workbook is protected?

Answer 1

Java tutorials-http://aboutjava.org/

Answer 2

Put this line of code as the 1st line of your macro within the Sub

ThisWorkbook.Protect password:="myPassword", Structure:=True, Windows:=False

put this line of code as the 1st line of your macro within the Sub

ThisWorkbook.Unprotect password:="myPassword"

Note: the password to unprotect/protect the workbook structure in the above case is myPassword (case sensitive), change that to yours.