macros in Excel 2007
 

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

macros in Excel 2007
 

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

macros in Excel 2007
 

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