View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JMay[_2_] JMay[_2_] is offline
external usenet poster
 
Posts: 1
Default Placing "DRAFT" just on Certain Sheets

The below code is perfect for toggling "DRAFT" on/off an
activesheet, but I need to modify it as follows. I'm lost
as to which way to turn/go. Any assistance would be
greatly appreciated.

My workbook has several tabs (worksheets). I need to
permanently place "DRAFT" on ALL worksheets (disallow
toggling) that DO NOT have the word "NOTES" as part of the
sheet name, example "IP-CUR NOTES" - Code would allow for
additional tabs (sheets) being added.

Thanks in Advance,
JMay