First thing is make a copy of the workbook before starting to mess about.

For shared files........................

Macros will run in shared workbooks but you would have unshare the workbook
before you could add or edit macros.

For regular workbooks you can just open the VB Editor by Alt + F11 and add or
edit macros.

See David McRitchie's site for help on getting started with VBA and macros.

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


Gord Dibben MS Excel MVP

On Mon, 1 Oct 2007 21:27:26 +0100, ab3d4u
wrote:


Most of us benefit by reading answers given to others (one way not to
repeat the same question). So far I have not this one. Here it is - I
see a lot of times the gurus suggesting "add this VBA code" kind of
answer. Most of us who work on shared files or files created by others
are really nervous about "messing up" our work environment. Does any
one know a step by step guide on how to do this. Once the confidence is
up, may be...
Gracie molto bene