Trying to create a new module

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Schubach - 24 Jul 2003 04:16 GMT

When I right-click on a worksheet name, then click on Insert, I don't see an
option to add a Module.

I'm running Office 2000 under WinXP Home.

Thanks,
Tim

Reply to this Message

EZ Money - 24 Jul 2003 13:35 GMT

Choose View Code from the right click menu. In the VBE, choose
Insert>Module.

Signature

Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

> When I right-click on a worksheet name, then click on Insert, I don't see an
> option to add a Module.
[quoted text clipped - 3 lines]
> Thanks,
> Tim

Reply to this Message

David McRitchie - 24 Jul 2003 19:27 GMT

Hi Tim,
I don't either. You should see "View Code" and that would be
for a Worksheet Event macros, not for regular macros.

Event Macros (for Worksheet macros)
http://www.mvps.org/dmcritchie/excel/event.htm

Getting Started with Macros (for macros into Standard Modules)
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> When I right-click on a worksheet name, then click on Insert, I don't see an
> option to add a Module.
>
> I'm running Office 2000 under WinXP Home.

Reply to this Message

Rate this thread: