for the second option, see Application Level events
http://www.cpearson.com/excel/appevent.htm

for the first, I would think not. You of course could write a macro to open
each workbook and perform any required actions, then save and close.

--
Regards,
Tom Ogilvy


"adehart" wrote:

Is there a way, through Windows Explorer to unprotect a whole directory of
password protected workbooks? I have a macro that will protect, save and
close each workbook but I still have to open each one to run it. Can I
somehow do it through windows explorer? Or, is there a way to make a macro
written in personal.xls run when a workbook is opened?