Is the error number 5?, do you have the pivot table name and sheets
names correct with no trailing spaces!

TomCon via OfficeKB.com;308307 Wrote:
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 'MS Office forums. More than 400,000 of Word, Excel,
Outlook, PowerPoint, Publisher, InfoPath discussions.'
(http://www.officekb.com)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86193