(ms excel 2003) If I have a particular workbook open which contains macros
and If I happen to walk away and the computer locks... upon unlock the vba
editor pops up automatically. This particular workbook didnt do this until I
added some lines of code that unprotected one of the sheets so the macro
could write to it and once it was finished it protected the sheet again.

Activesheet.Unprotect ("My_Password")
Activesheet.Protect Password:="My_Password"