Macros

Hi Lauren,

Thank you for your question.

Every time you record a macro, in the background excel is writing the Visual basic code for every mouse click.

Yes you can edit the macro but it needs to be edited in the Visual Basic window. In order to make changes to the macro, you will have to know Visual Basic code and where that macro was stored.

Alternatively, delete the macro through Tools, Macro and Macros and then record the correct procedure.

I hope this answers your question.

Regards

Simon