+ Reply to Thread
Results 1 to 5 of 5

How to toggle on/off an event code which highlights active row and column?

  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2010
    Posts
    5

    How to toggle on/off an event code which highlights active row and column?

    I'm looking for a way to to toggle on and off the function of highlighting the active cell row and column. The code for the highlighting works as need (besides erasing all color formatting), but I want to be able to cut it on and off for my needs. Here's the functioning code.
    Please Login or Register  to view this content.
    What I want is to put a check box or button in the worksheet (let's say "sheet 1") and have the code refer to it to activate. Here is something I tried, which does not work, but it will provide some insight.
    Please Login or Register  to view this content.
    Please help! Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: How to toggle on/off an event code which highlights active row and column?

    Take the brackets of your if statement:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-09-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to toggle on/off an event code which highlights active row and column?

    I've tried that, but I get a run-time error of "Invalid procedure call or argument." To give more info, the "BH3" is the cell which is fed by the embedded checkbox. I placed the entire statement from above on the 1st line in the code. Should it be place elsewhere? Thanks for the reply.

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: How to toggle on/off an event code which highlights active row and column?

    Change cells to range
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-09-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to toggle on/off an event code which highlights active row and column?

    Thanks! That little detail had me stomped!

+ Reply to Thread

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