View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BeSmart BeSmart is offline
external usenet poster
 
Posts: 102
Default If sheet not created show a 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