Hi all,

I don't know if I'm being too ambitious here or not.

I have a simple UserForm called Task1 that comprises check boxes and command button

The command button sends the workbook via email to the next user.

What I want to do is this. When the mail recipient opens up the workbook, the next UserForm is automatically loaded eg UserForm called Task2

This user then completes his tasks and mails it to the next user, who opens the workbook and UserForm called Task3 is automatically opened etc.

Can I control the opening of the relevent UserForm by using a variable so that UserForm(variable) is opened automatically when the new mail recipient opens the workbook?

Also how could I control the variable ie increment it before the workbook is saved?

best regards

Steve

I have now worked out how to do this, thanks