using default excel screens

  • Thread starter Thread starter ashwini
  • Start date Start date
A

ashwini

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
 
Try something like

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



--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wait till pivot finishes refreshing 1
Pivot Table Refreshing 2
Excel VBA For excel 0
VB to get to top of page 2
refresh multiple pivot tables in workbook 2
ShowDetail on PivotTable does not work in VBA 0
Using VBA to create charts 1
How I can set dynamic pivot table ONLY when I have enough data point 1

Back
Top