Results 1 to 12 of 12

How do I make Sheet Code available in all sheets

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2009
    Location
    South Africa
    MS-Off Ver
    Office 365
    Posts
    59

    How do I make Sheet Code available in all sheets

    I found sheet code on the forum that highlights the both the entire row and column when a cell is selected.

    This is great, but is there a way I can make this an add-in so it is easily available in all workbooks and sheets?

    Thanks!

    Code:
    Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
       Cells.Interior.ColorIndex = -4142
       Target.EntireRow.Interior.ColorIndex = 8
       Target.EntireColumn.Interior.ColorIndex = 8
    End Sub
    Last edited by antonf; 10-20-2009 at 10:42 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