Results 1 to 5 of 5

Toggle Button, Macro Off/On Help

Threaded View

ike609 Toggle Button, Macro Off/On... 08-15-2012, 05:56 PM
protonLeah Re: Toggle Button, Macro... 08-16-2012, 04:31 PM
ike609 Re: Toggle Button, Macro... 08-17-2012, 12:12 AM
Cutter Re: Toggle Button, Macro... 08-17-2012, 05:38 AM
ike609 Re: Toggle Button, Macro... 08-17-2012, 09:27 AM
  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    13

    Question Toggle Button, Macro Off/On Help

    I have a macro in Sheet1 that will highlight selected row when you click on a cell.

    What i would like to do is use a activex toggle button to either enable this when pressed or disable it when it is not pressed.

    I cannot seem to get it laid out where it will work.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Cells.FormatConditions.Delete
    With Target
    With .EntireRow
    .FormatConditions.Add Type:=xlExpression, Formula1:=True
    With .FormatConditions(1)
    .Interior.ColorIndex = 20
    End With
    End With
    End With
    End Sub

    Thanks, Gary
    Last edited by ike609; 08-15-2012 at 07:24 PM.

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