Kevin,

That is probably because you have not put the code in the right place. As
Dave said, it need to go in the ThisWorkbook code module, and that it
becomes an event triggered by Save (button, Ctrl-S, etc). To get at this
module,

- go into the VB IDE
- select the workbook, if there is a plus sign beside it, click that to open
it
- you'll now see an item called Microsoft Excel Objects, click this if it
also needs opening
- you'll now see the ThisWorkbook object. Double click it to open the code
pane, and copy Dave's code into there.

--

HTH

Bob Phillips

"Kevin Simons" wrote in message
...

Thx,

I needed to change a bit of code but it works. The funny thing is that
it only works when I ask to run. If I click on the save button he does
not start the macro.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!