Background macros?

S

Stu78

Is it possible to have a macro run in the background so that a user ca
open and edit a worksheet as normal, but when they close or save tha
sheet (or exit Excel) the macro catches the action and springs to life


Basically I need it to automatically password protect al
worksheets/books that are saved.

Any tips or ideas would be appreciated.

Thanks

Stuar
 
F

Frank Stone

hi,
from my experiences, it is not wise to run a macro in the
background while anyone is doing anything in the file.
but for your purposes i think you can put your code in the
before close event of the workbook.
 
Top