Triggering Macros

[Guest]

I am very new to macros, but I have written several and mapped them to
buttons. I have seen some sample code that is triggered when the user saves,
or doubleclicking etc. Does anybody have a good reference on how to do this,
and what can be triggered?

In particular I want to know how to trigger a macro when the users saves,
and when they print (different macros for each trigger).

 

[Don Guillett]

Look in the ThisWorkbook module (right click the excel icon in the upper
left of the screen). In the left window select workbook>in the right window
are your events.

 

[Norman Jones]

Hi Sloth,

For an introduction to event macros, which is what you are referring to, see
David Mcritchie's Events page at:

http://www.mvps.org/dmcritchie/excel/event.htm

For an in depth discussion of Event procedures see Chip Pearson's Events
page at:
http://www.cpearson.com/excel/events.htm

Specifically, look at the Workbook's Before_Save and Before_Print events.