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
|