+ Reply to Thread
Results 1 to 3 of 3

Macro Publishes Print Area to MHT with Gray Background

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    15

    Macro Publishes Print Area to MHT with Gray Background

    Hello Excel Experts,

    I have managed to setup a table in Excel 2010 with a macro which updates the cell data then publishes it to a SharePoint location in a MHT format. Macro works great, but the background of the Print Area table is gray instead of white. Somehow I managed to get another user viewing the SharePoint site and see it as a white background.

    Is this something I need to correct in the macro or the spreadsheet? I found someone with the same issue on the Microsoft Office Community forum. It was posted in Sept of 2013 with no replies. Has anyone out there with the same issue successfully change the background of the MHT formatted table?

    Thanks,
    Ruezo

  2. #2
    Registered User
    Join Date
    08-14-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Macro Publishes Print Area to MHT with Gray Background

    Doing some additional research and testing, it looks like this may be strictly a SharePoint issue as oppose to Excel.

    Thanks,
    Ruezo

  3. #3
    Registered User
    Join Date
    08-14-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Macro Publishes Print Area to MHT with Gray Background

    Looks like no one had any ideas about this. But, I solved it myself. It turns out that the gray background is a setting within Internet Explorer. So, problem solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro - Set Print Area for Changing Data Area
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-27-2013, 04:19 AM
  2. Macro to change cell background from gray to white
    By t0m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2011, 04:08 PM
  3. [SOLVED] Why I get gray area in sheet tab of page setup? can't resize area.
    By joey0617 in forum Excel General
    Replies: 1
    Last Post: 07-15-2006, 12:35 PM
  4. [SOLVED] Graph format? i.e. no gray background
    By Paul Burton in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-06-2006, 08:00 PM
  5. How do I place an average bar gray-scale in the background?
    By Red_Ink in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-22-2005, 10:05 PM

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