Basically I want to be able to track changes (which requires shared workbook)
and still use macros (which seems to be switched off ). Is there an
alternative or a way around the problem (EXcel 2003)

Also can you tell me how to change the keystroke designation for a macro so
that it actually sticks? (I've tried to do so under macros, options but it
doesn't stay in there - keeps changing back to the original keystroke)