Creating a Macro
 

Excel 2002
When I go Tools/Macro/Macros the *Create* box is grayed out.

What to do to go straight to VBE?

TKS in advance

Gal

Creating a Macro
 

alt f11

--
Don Guillett
SalesAid Software

"Galumpher" wrote in message
...
Excel 2002
When I go Tools/Macro/Macros the *Create* box is grayed out.

What to do to go straight to VBE?

TKS in advance

Gal

Creating a Macro
 

Thanks , but that just takes me into another [existing] macro that came
with the xls.
I'm a newbie that just wants to create a new macro [without recording] so
why is the *create* box unavailable?

Gal
"Don Guillett" wrote in message
...
alt f11

--
Don Guillett
SalesAid Software

"Galumpher" wrote in message
...
Excel 2002
When I go Tools/Macro/Macros the *Create* box is grayed out.

What to do to go straight to VBE?

TKS in advance

Gal

Creating a Macro
 

the alt f11 takes you to the vbe (visual basic editor). If not in a module
use the insert to insert a module and then type in
sub createit
the () will be added for you along with end sub line.
Create away.

--
Don Guillett
SalesAid Software

"Galumpher" wrote in message
...
Thanks , but that just takes me into another [existing] macro that came
with the xls.
I'm a newbie that just wants to create a new macro [without recording] so
why is the *create* box unavailable?

Gal
"Don Guillett" wrote in message
...
alt f11

--
Don Guillett
SalesAid Software

"Galumpher" wrote in message
...
Excel 2002
When I go Tools/Macro/Macros the *Create* box is grayed out.

What to do to go straight to VBE?

TKS in advance

Gal