I have a macro where I create a pivot table on a new sheet, then want to just take the text values of it without the drop down list. What I end up doing is selecting the current region then copying and pasting it onto a new sheet, only pasting the values. At the end of the Macro I 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 Delete 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 making this for someone, and it does not make sense for them to hit the delete button everytime. Either that or if I could make the pivot table and somehow automatically convert it to text values. I don't want a pivot table to be seen.

Any thoughts or ideas would be great!

~J