Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Macro the right way? | Excel Worksheet Functions | |||
Creating a macro | New Users to Excel | |||
Creating a Macro | Excel Programming | |||
Help Creating a Macro | Excel Programming |