LS

I have macros in my workbooks to move date ranges on charts and to refresh a
pivot when clicking on the pivot tab.

How can I replicate the functionality best when moving to Excel 2007?

just switching the workbook from 2003 to 2007 diasables the macros.

A pondering Texas Tonie

Hi

When you say moving to 2007 disables the macros, did you save the file as an
xlsm file?
If you save it as a standard .xlsx file, you will lose your macros.
Click the round office buttonSave asExcel Macro Enabled workbook, then you
should be OK

--
Regards
Roger Govier

"Texas Tonie" wrote in message
...
LS

I have macros in my workbooks to move date ranges on charts and to refresh
a
pivot when clicking on the pivot tab.

How can I replicate the functionality best when moving to Excel 2007?

just switching the workbook from 2003 to 2007 diasables the macros.

A pondering Texas Tonie

Are you sure you enabled macros when you opened the workbooks?

You get a warning banner in xl2007. You may have missed it.

Texas Tonie wrote:

LS

I have macros in my workbooks to move date ranges on charts and to refresh a
pivot when clicking on the pivot tab.

How can I replicate the functionality best when moving to Excel 2007?

just switching the workbook from 2003 to 2007 diasables the macros.

A pondering Texas Tonie

--

Dave Peterson