ColinCoady
New Member
- Joined
- Mar 21, 2019
- Messages
- 35
I can't figure out why this code won't print a PDF object ("AcroExch.Document.DC","") I have on a sheet.
I stuck the sh.select just to see if the macro passed the PrintObject line . Only had 1 PDF object on the sheet for testing.
No errors come up but nothing prints.
Any ideas why?
-Colin
I stuck the sh.select just to see if the macro passed the PrintObject line . Only had 1 PDF object on the sheet for testing.
No errors come up but nothing prints.
Any ideas why?
-Colin
Code:
Sub PrintAll()
'
' PrintAll Macro
' Prints all objects on sheet named Docs
'
Dim sh As Shape
Sheets("Docs").Select
For Each sh In ActiveSheet.Shapes
sh.ControlFormat.PrintObject = msoTrue
sh.Select
Next sh
End Sub