Macros can still be used on shared workbooks.

You cannot Write, record, change, view, or assign macros.

You can run existing macros that don't access unavailable features. You can
record shared workbook operations into a macro stored in another nonshared
workbook.


Gord Dibben MS Excel MVP

On Mon, 30 Apr 2007 22:18:01 -0700, Steve
wrote:

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)