recorded macro keeps disappearing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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.
 
Back
Top