I have a macro in a WB that has been working for years. Even when i moved to
XL2007, it worked fine, until i saved as xlsm. It will not work when the
book is saved as xlsm (so, my workaround is to keep using the xls version).

Here is the line that gives the error:
pt(1).PivotFields("Acct").CurrentPage = "Moe"

The error is "invalid procedure call or argument".

Any thoughts or ideas? How to fix/work around? Would be nice to save as
xlsm, since XL autrecovery saves are soooo slow with XLS for a fairly large
workbook.

Thanks, tom

--
Message posted via http://www.officekb.com