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)