Tags: color, connection, excel, interior, microsoft, msdn, software, transparency, transparent

Transparency for interior color?

On Microsoft » Microsoft Excel

1,719 words with 1 Comments; publish: Fri, 23 May 2008 03:16:00 GMT; (30693.75, « »)

Hi all,

I would like to ask you about, how can I do(if it's possible), that the

interior color will be transparent where it's in connection with the

gridlines' (Like when I select some cells)

So I want, that the gridlines don't disappeare when I get an interior

color for the cells.

Thanks

--

reloader

---

reloader's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27827

View this thread: http://www.excelforum.com/showthread.php?threadid=530472

All Comments

Leave a comment...

  • 1 Comments
    • then add the gridlines with the borders icon or a macro using borders

      Sub borderoneline()

      Selection.Borders.LineStyle = xlContinuous

      End Sub

      --

      Don Guillett

      SalesAid Software

      dguillett1.excel.questionfor.info.austin.rr.com

      "reloader" <reloader.25ugzm_1144329901.6789.excel.questionfor.info.excelforum-nospam.com> wrote in

      message news:reloader.25ugzm_1144329901.6789.excel.questionfor.info.excelforum-nospam.com...

      > Hi all,

      > I would like to ask you about, how can I do(if it's possible), that the

      > interior color will be transparent where it's in connection with the

      > gridlines' (Like when I select some cells)

      > So I want, that the gridlines don't disappeare when I get an interior

      > color for the cells.

      > Thanks

      >

      > --

      > reloader

      > ---

      > reloader's Profile:

      > http://www.excelforum.com/member.php?action=getinfo&userid=27827

      > View this thread: http://www.excelforum.com/showthread.php?threadid=530472

      >

      #1; Fri, 23 May 2008 03:18:00 GMT