Pivot table pop ups

[realniceguy5000]

I have some code that creates a pivot table the only problem is that two small windows keep poping up on the screen, I thought I could use the Application.DisplayAlerts = False at the begining of the script to disable those windows?

The windows that pop up are Pivot Table and pivot table field list.
Here is my code.

Any Idea what I did wrong?

Thanks as always ,Mike

Please Login or Register  to view this content.

[realniceguy5000]

Just wanted to let everyone know I am now looking for help on another site. I will post an anwser and link if I get any information...

Thank You, Mike

[royUK]

It would be easier to test with the workbook.

[realniceguy5000]

I have placed a sample book here.

Let me know if it helps any.

Thank You, Mike

[realniceguy5000]

Here is some info in case someone needs it.

I was able to get the anwser from another site.

Please Login or Register  to view this content.

Which appears to have done the trick.

http://www.mrexcel.com/forum/showthr...90#post1779190

Thank You,Mike

[royUK]

Try this

Please Login or Register  to view this content.

[realniceguy5000]

Thank You Roy...Everything is working fine now.

Much Appreciated, Mike

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save