modifiying macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KBV - 04 Jul 2006 22:06 GMT

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

Reply to this Message

L. Howard Kittle - 04 Jul 2006 22:31 GMT

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

>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

Reply to this Message

Gord Dibben - 04 Jul 2006 22:33 GMT

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

>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

Reply to this Message

Don Guillett - 04 Jul 2006 22:36 GMT

alt f8

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>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

Reply to this Message

Rate this thread: