Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-17-2017, 09:16 AM
Logit Logit is offline Printout with both colour and b/w Windows 10 Printout with both colour and b/w Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Paste this into a routine module, call with Command Button :

Code:
Option Explicit

Sub ClearPrint(WorksheetName)
    Application.DisplayAlerts = False
    Sheets("Sheet1").Copy After:=Sheets(3)
    With Sheets(1).Cells.Interior
        .Pattern = xlNone
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    Sheets(1).PrintOut
      
    Sheets("Sheet1").Delete
    ActiveSheet.Name = "Sheet1"
   
Dim i As Integer
Dim j As Integer

    For i = 1 To Sheets.Count
          For j = 1 To Sheets.Count - 1
                If UCase$(Sheets(j).Name) > UCase$(Sheets(j + 1).Name) Then
                   Sheets(j).Move After:=Sheets(j + 1)
                End If
          Next j
    Next i
    Sheets("Sheet1").Select
    Range("A1").Select
   Application.DisplayAlerts = True
End Sub

Sub prnt()
    ClearPrint "Sheet 1"
End Sub
The code is set for Sheet 1 Range A1:F18 .... edit as required.
Attached Files
File Type: xlsm Print BW.xlsm (20.4 KB, 13 views)
Reply With Quote
 

Tags
printout



Similar Threads
Thread Thread Starter Forum Replies Last Post
Track Changes Printout Dana-H Word 2 09-22-2016 05:45 AM
Insert File Printout w/ PDF fail jsilvoy OneNote 0 03-05-2015 06:44 PM
PDF printout distorted Peter c OneNote 1 12-07-2014 07:59 PM
Printout with both colour and b/w MS Project - Resource usage printout scrinmemphis Project 1 02-22-2013 02:30 PM
Printout problem with customized bullets eroock PowerPoint 2 12-27-2009 02:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:03 AM.


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