View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default combine two macros

Sub MacroA()
'Your Code Copy... Insert... Blah Blah
Call MacroB 'Prompts... Blah Blah...
End Sub

HTH

Die_Another_Day
Lisa wrote:
I have a macro that will copy and insert a new worksheet and I have a macro
that will prompt for the name of the sheet. How do I combine both macros to
work at the same time. Copy, insert, prompt?

Lisa