recorded macro keeps disappearing

[tina]

Is there any way to record and save a macro on a worksheet which tracks changes made to it? I have clicked track changes on my worksheet and everytime a record a macro it disappears when I come back into the programme. Is there anyway to get around this ?

 

[Debra Dalgleish]

You can't record a macro in a shared workbook. You could turn off
sharing, record the macro, then turn sharing back on.

Or, record the macro into another workbook, and run it from there.
That way, you wouldn't lose the changes you're tracked in the shared
workbook.