had the same problem the other way round- when using a macro created with excel 2003 in excel 97.

I decided to just exclude the tintandshades from the code, because it had no effect in 97 anyway and the macro worked out afterwards.

I experienced the same problem with ThemeFont

' .TintAndShade = 0
' .ThemeFont = xlThemeFontNone





Posted as a reply to:

tintandshade

You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx