Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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






  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default 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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Macro the right way? Hvns Excel Worksheet Functions 2 January 25th 10 09:16 PM
Creating a macro Gene Goldenfeld New Users to Excel 10 May 5th 05 04:28 PM
Creating a Macro DeRizzio[_2_] Excel Programming 10 March 26th 05 01:37 PM
Help Creating a Macro milton Excel Programming 3 October 21st 03 09:04 PM


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"