View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Proper way to create new macro

I just type two lines

Sub Test

end Test

Most of the time I put the macros in Module sheets so I Have to use the VBA
menu to create the Module sheet Insert - Module. You can just type
macros into sheets and thisworkbook without inserting a module.

"Simon" wrote:

I hit record then immediate after I hit stop then, step in and type in
code.

When is the best way?