Microsoft Office Tutorials and References
In Depth Information
Creating a PPT Presentation from a Pivot Chart
' * * * * *¶
Sub DeleteBar()¶
On Error Resume Next¶
Application.CommandBars(BarName).Delete¶
End Sub¶
' * * * * *¶
Sub Auto_Open()¶
'Create the bar when the workbook opens¶
CreateBar¶
End Sub¶
' * * * * *¶
Sub Auto_Close()¶
'Delete the bar when the workbook opens¶
DeleteBar¶
End Sub¶
Exl
Tips: Customize the toolbar that remains visible by changing the 'CreateBar' procedure as
desired.
You can call the macro by pressing a toolbar icon to show or hide the toolbars.
Creating a PPT Presentation from a Pivot Chart
This procedure demonstrates how to create a Microsoft PowerPoint
presentation based on a Pivot Chart that includes one Page field.
Example file:
E032.xls
Scenario: Pivot Charts are very useful tools, but distributing
them becomes complicated. Usually, the people receiving them
want only to see their respective piece of the chart. For
example, you may want to create a PowerPoint presentation for
each of the sales regions for the company that can be easily
grasped by all the people involved (including supervisors).
 
Search JabSto ::




Custom Search