modifiying macros

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

Guest

I understand how to record a macro. But if I want to modify it (to repeat
throughout the sheet), how do I access the code to mofidy?

Thanks,
KBV
 
Alt + F11, double click on Modules then double click Module1. Should see
your recorded code there. (May be other modules...ie 2, 3 etc.)

Or right click on the sheet tab and click View Code.

HTH
Regards,
Howard
 
Tools>Macro>Macros.

Select the macro by name and "Edit"

Alternative..............Hit T + F11 to open VB Editor.

CTRL + open Project Explorer.

Find your workboo/project and expand it.

Double-click on a Module to open.


Gord Dibben MS Excel MVP
 
Back
Top