View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dch3 dch3 is offline
external usenet poster
 
Posts: 15
Default Using macros in an external worksheet

What is the best way to setup Excel if I need to access macros in an external
worksheet and run them in a variety of worksheets? I tried saving them in a
..xls worksheet and then setup Excel to open the worksheet when the app opens,
but the worksheet is always displayed. Should I save the worksheet as a *.xla
and then add it as an add-in?