using default excel screens
 

I want to prompt the user to go through the pivot table wizard of
Excel. I have my own user inputs screens before that. After inputting
some details from user. Can I redirect the user programmatically to
pivot table wizrd screen

using default excel screens
 

Try something like

Range("A1").Select
Application.Dialogs(xlDialogPivotTableWizard).Show



--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
I want to prompt the user to go through the pivot table wizard of
Excel. I have my own user inputs screens before that. After inputting
some details from user. Can I redirect the user programmatically to
pivot table wizrd screen