Thanks for your response.
When someone clicks a "proceed to next worksheet" button, I need the attached macro to check that a cell (say B1) has the word "yes" entered into it. If so, I need the macro to bring up another worksheet. If the cell (B1) hasn't been completed, I need a message box to pop up stating "You must complete cell (B1) before proceeding".
Any further help would be much appreciated.