Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2019, 05:03 PM
chubbychub chubbychub is offline print specific pages in vba Windows 10 print specific pages in vba Office 2013
Novice
print specific pages in vba
 
Join Date: Feb 2019
Posts: 5
chubbychub is on a distinguished road
Default print specific pages in vba

I have the below code that will not print the command button, but I only want certain pages printed, for example I just want pages 1 and 3.
Code:
With ActiveDocument 
.Shapes(1).Visible = msoFalse 
.PrintOut Background:=False 
.Shapes(1).Visible = msoTrue 
End With
please help, thanks in advance.
Reply With Quote
  #2  
Old 02-21-2019, 05:54 PM
Guessed's Avatar
Guessed Guessed is offline print specific pages in vba Windows 10 print specific pages in vba Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

PrintOut has a large number of parameters which it appears you haven't explored. Have a look at https://docs.microsoft.com/en-us/off...6)%26rd%3Dtrue
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
print specific pages in vba Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
can word: make variables, find appropriate pages, fill out pages with variables, print only those 20GT Word VBA 1 10-15-2014 09:48 PM
print specific pages in vba Tick box to be able to save or print specific pages Jack Byrindi Word 9 01-21-2014 09:36 PM
Select specific pages to print or save Jack Byrindi Word VBA 0 01-16-2014 03:14 PM
Print attachment when it arrive in specific folder with specific subject visha_1984 Outlook 1 01-30-2013 10:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft