combine two macros
 

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

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