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

--
Message posted from http://www.ExcelForum.com

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.

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


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

Any tips or ideas would be appreciated.

Thanks

Stuart


---
Message posted from http://www.ExcelForum.com/

.