Hi Lukas,
See http://www.mvps.org/dmcritchie/excel/backup.htm#demand
the second macro is an Event macro
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lukas" wrote in message ...
I have a workbook that upon saving, i wish for it to produce a carbon copy on
a shared drive for public viewing, but keep the original secure. And each
time I update the original, the version on the shared drive will be
overwritten.

I'm not sure of the best method to go about this, if it is possible, or if a
macro can be made. I am pretty good in excel, but have little experience in
creating macros.

Help!

(i'm using Microsoft Office 2000)