VBA code to open 3D dialog window

T

Tony Bender

I have an Excel application that includes charts and tables. On my
Pie Charts I want to add a macro that opens the 3D Chart options.
This is to make it easy for the user to adjust the design of the pie.

I know the user could do this through a series of mouse clicks, but I
just wanted to make it easier.

Thank you,

Tony
 
J

Jim Thomlinson

Not too sure but I think this is the dialog you want...

Application.Dialogs(xlDialogChartType).Show
 

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

Extract RGB values for selected chart series 2
Making two pie charts look alike 4
Copy Excel chart to PPT that is already open 5
How to create multiple bar charts at the same time? 0
Delete any Lables with "0%" value in pie chart 2
Need urgent help with VBA 2007 CHARTWIZARD method !!! 3
Why do charts disappear? 2
Creating Charts in VBA Code 4

Top