the code is put into the
VB editor (in 2007 found under the developer tab),
can't remember what it is in 2003 or before.
here you can choose the option of individual sheets or the complete workbook.
keep asking - only way to learn (or i believe anyhow!)
edit *or as above!! lol
