Why not just create it if it doesn't exist?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BeSmart" wrote in message
...
Hi all

I have a workbook with multiple sheets including one that is generated by
the user (via a button/macro).

I need a code that look for a sheet that "contains" MBA in it's name (it
may
contain other words in the sheet name).

If the worksheet is not found then the message "Create MBA first" must
appear, stopping the macro. The user then should click on an OK button,
and
fix the problem before re-running the macro.

Help with this would be greatly appreciated.
--
BeSmart