View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KimberlyC KimberlyC is offline
external usenet poster
 
Posts: 124
Default Deleting a sheet via code-- different criteria

Hi Again...

I've thought of a better way to remove unwanted worksheets from my
workbook....

I need to run code that will delete all worksheets in my activeworkbook that
have "Delete" in cell A3 of the worksheet.
Cell A3 has a formula in it of each worksheet that determines if the sheet
needs to be deleted or not... if it needs to be deleted.. then, the formula
returns "delete"...otherwise..it's blank "".


I think this will work better than my previous post......


I'm not sure how to do this ... so any help is greatly appreciated..

Thanks in advance,
Kimberly