Can Macro Recorder record macro changes?

[lavoo]

Hi, I was wondering if anyone knows if excel macro recording function is able to record changes to made to macro scripts?
I have a template for user which is fully protected to avoid them changing formats and this template has an existing macro script (which is also locked).
I do not wish to share any password for unprotecting the worksheets or the macros.
However, I discovered an error with the existing macro and wish to update it.
I would usually use macro recorder to record any change in cell formula within the workbook, however, I tried to record the change in macro, but it doesn't record it.

Any suggestion would be appreciated.

 

[Joe4]

The Macro Recorder can only record actions done on the worksheet.
It cannot record changes you make to VBA code.

 

[lavoo]

The Macro Recorder can only record actions done on the worksheet.
It cannot record changes you make to VBA code.

Thanks Joe for your reply. I figured as much too.