Results 1 to 3 of 3

Remove fill on printing - Cell Specific

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2008
    Location
    Boston, MA, USA
    MS-Off Ver
    2013
    Posts
    41

    Remove fill on printing - Cell Specific

    Good evening,

    I found this post http://www.excelforum.com/excel-prog...move-fill.html regarding the removal of cell shading when printing and was wondering if the solution could be made so that I could have the remove fill on a number of specific cells within the worksheet rather than the whole document?

    This was the code that was suggested in the previous post

    Private Sub Workbook_BeforePrint(Cancel As Boolean)
       Cells.Interior.ColorIndex = xlNone
    End Sub
    Any help you could offer would be greatly appreciated.
    Last edited by BrianOfNazareth; 11-26-2010 at 03:44 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1