I have a muti-sheet workbook with many macros on each sheet (i.e. not in
modules) and in userforms.
I need to be able to run a macro on one sheet then makes another sheet
active and then calls a macro stored in that sheet.

So Sheet1 has a number of buttons on it. One of them says "sort" and the
user presses this and the code behind the button runs. On Sheet2 there
are more command buttons and one of these says "check data". The plan is
that this button does some work then makes sheet1 active and then runs the
code under the commandbutton called "Sort". How do I make that happen.

Finally can you explain what is the difference/advantage of using Modules
to hold the code over having it in the sheets behind command buttons.

many thanks

Peter


--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/