Skip to content

Instantly share code, notes, and snippets.

@etaf
Last active August 29, 2015 14:27
Show Gist options
  • Save etaf/962283da7b5fc7a222a5 to your computer and use it in GitHub Desktop.
Save etaf/962283da7b5fc7a222a5 to your computer and use it in GitHub Desktop.
VB ProcessBar
Sub ProgressBar()
' by dukenuke@newsmth.net
' Sun Jul 11 00:06:13 2010
Dim mySlides As Slides
Dim pageBar As ShapeRange
Dim pageSHower As Shape
Dim pageWidth, pageHeight, pageStep
Set mySlides = Application.ActivePresentation.Slides
pageWidth = Application.ActivePresentation.SlideMaster.Width
pageHeight = Application.ActivePresentation.SlideMaster.Height
pageStep = pageWidth / mySlides.Count
On Error Resume Next
For i = 2 To mySlides.Count
Set pageBar = mySlides.Item(i).Shapes.Range(Array())
Set pageBar = _
mySlides.Item(i).Shapes.Range(Array("RectanglePageNum"))
If IsNull(pageBar) Or pageBar.Count = 0 Then GoTo newBar
Set pageSHower = pageBar.Item(1)
GoTo nextPage
newBar:
Set pageSHower = mySlides.Item(i).Shapes.AddShape( _
msoShapeRectangle, 0, _
pageHeight - 3, i * pageStep, 3)
pageSHower.Name = "RectanglePageNum"
nextPage:
pageSHower.Fill.ForeColor.RGB = RGB(64, 64, 64)
pageSHower.Line.Visible = msoFalse
pageSHower.Width = i * pageStep
pageSHower.Top = pageHeight - 8
pageSHower.Left = 0
pageSHower.Height = 8
Next
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment