Doug

Shared workbooks can have and run macros that were existing prior to the
workbook being shared.

After sharing the workbook macros can't be added, viewed or edited.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 20:48:03 -0800, "Doug Glancy"
wrote:

It seems a shared workbook can't have macros, so that's why I recorded the
macro in another workbook. Maybe that's why it didn't work for you.