Thread: Managing Macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stilltrader47 Stilltrader47 is offline
external usenet poster
 
Posts: 36
Default Managing Macros

For the worksheet I am working on, do I need to keep all macro statements in
sheet 1 (VBA Project, MS Excel Objects)? After I execute Alt-F11.

Most of the updates to the worksheet can be combined in the same macro.
Different execution steps and logic required may require a different macro.
Can I have multiple macros in sheet 1 (in VBA Project)?

Is a separate sheet required in VBA editor only when a separate worksheet
is used (ie. worksheet 3 reads the macros in sheet 3 (VBA Editor) only?

Thanks for clearing this up for me - Tom