launching macro on workbook loading

  • Thread starter Thread starter Ric
  • Start date Start date
R

Ric

Hi,

Is there a way to have a macro automatically run every time an excel
workbook is opened, where the macro in question resides in the personal.xls
or an add-in rather than being part of the document that is being loaded?

Thanks,
Ric
 
Tom said:
If you want to instantiate application level events and have the open
event check each workbook opened to see it is the one - then run the
code.

see Chip Pearson's site on application level events

http://www.cpearson.com/excel/AppEvent.htm
Click to expand...

Thanks. This works.

I have one annoying problem, though. I now have a macro that runs whenever a
workbook is opened that does a search and replace of a text string on each
sheet of the workbook. However, now I'm always asked if I want to save
changes when I close a workbook, even if the string searched for did not
exist in that workbook. Is there any way to do a search and replace but
leave the "changed" status of the workbook as unchanged if the text string
was not found?

Thanks,
Ric
 
workbooks("MyWorkbook.xls").Saved = True

will mark the workbook as unchanged.

so if your macro makes not changes, have it set this property to true after
it has done its search and found no match.
 
Helpful as usual. Thanks!

Ric

Tom said:
workbooks("MyWorkbook.xls").Saved = True

will mark the workbook as unchanged.

so if your macro makes not changes, have it set this property to true
after it has done its search and found no match.
Click to expand...
 
Back
Top