Background macros?

  • Thread starter Thread starter Stu78
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet CLOSE related macros 4
Background copy macro 8
including macro in protected worksheet 2
Problem in adding macro to ribbon through Add-in 7
Save All Worksheets as CSV 7
Hide Macro 3
Novice - using macro to protect with password 10
Auto Save 2

Back
Top