I have a client who wants to create spreadsheets using VBA - Pivot Tables &
Macros which will correctly run in both 2003 and 2007 Excel.

What are some best practices for this?

Thanks