View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anniebella Anniebella is offline
external usenet poster
 
Posts: 1
Default generic macro on close of excel workbook

Hi,
I need to run a macro whenever a spreadsheet in a partifcular folder is
closed & changes have been made to it. I have tried to put the macro in the
Personal.XLS but this is not being run when the updated spreadsheet is
closed.
What do I need to do, without having to define the macro in every spreadsheet.
THanks
Anne