+ Reply to Thread
Results 1 to 2 of 2

Active X Checkbox Linkage - in worksheet

  1. #1
    Registered User
    Join Date
    09-29-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    27

    Active X Checkbox Linkage - in worksheet

    Hi,

    I have got three active x checkboxes in the workbook, one in the each different worksheet.

    I want a way, if I click on any of this checkbox, the other two checkboxes enables too and same goes for the disable action.

    Any idea if it can be acheived.

    Please note that the worksheets are protected, so any code would require unprotecting the worksheets and then protecting it again (As I want them to be protected).

    Regards

    Umesh Banga

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: Active X Checkbox Linkage - in worksheet

    The simplest way to do this is to set the LinkedCell in all three checkboxes to the same cell.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Keeping the linkage intact between vba code to worksheet buttons
    By highlystrung in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2014, 06:58 PM
  2. Embedding a checkbox in a cell (not cell linkage !)
    By Mr_Nix in forum Excel General
    Replies: 0
    Last Post: 02-04-2010, 06:45 AM
  3. worksheet linkage
    By garyww in forum Excel General
    Replies: 2
    Last Post: 08-20-2006, 10:39 PM
  4. worksheet linkage
    By garyww in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2006, 11:09 PM
  5. worksheet linkage
    By garyww in forum Excel General
    Replies: 0
    Last Post: 08-18-2006, 10:54 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