I have a macro where I create a pivot table on a new sheet, then want t
just take the text values of it without the drop down list. What I en
up doing is selecting the current region then copying and pasting i
onto a new sheet, only pasting the values. At the end of the Macro
want to delete the sheet with the Pivot Table on it that I'm not using
Even with a Macro, it still prompts me and makes me click the Delet
Button. It says "Data may exist in the sheet(s) selected for deletion
To permanently delete the data, press Delete".

Is there any way around this so I don't have to click it? I'm makin
this for someone, and it does not make sense for them to hit the delet
button everytime. Either that or if I could make the pivot table an
somehow automatically convert it to text values. I don't want a pivo
table to be seen.

Any thoughts or ideas would be great!

~

--
nbaj2
-----------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...fo&userid=3648
View this thread: http://www.excelforum.com/showthread.php?threadid=56302