Stu

Perhaps you are not substituting correctly the names of your sheets
into Toms code.

Suppose you have named your sheets: Apples, Bananas, Cherries, Plums,
and Prunes

If you want your code to run in all sheets EXCEPT Bananas and Plums
then try this:

Sub MySub()

Select Case activesheet.name
' sheets not to run with
Case "Bananas", "Plums"
exit sub 'This will keep your code from running on these 2 sheets
End Select
'Add your code here that will run on the other sheets
'............

End sub



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/