+ Reply to Thread
Results 1 to 2 of 2

Macro or VBA code to update non primary sheets based on checkbox

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Macro or VBA code to update non primary sheets based on checkbox

    I want to run a macro or VBA to update seven different work sheets based on the seven different checkbox. I have the macro to transfer the data. The problem come in with the checkbox. The code updates no matter what. It updates on true and on false. I only want it to update on true. Each check box goes with its own subsheet. I attached the file. Final placement of things are not in place and things are visible that will be hidden.
    Thanks JB
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro or VBA code to update non primary sheets based on checkbox

    Hello

    Welcome to the Forum!

    The macro below should work after you have set sheet protection and locked cells etc. If not let me know if you have any problems. I have added the macro to your workbook and attached it to your button. The macro is in Module2.

    I am guessing these logs are for gas chromatographs based on the GC prefix, column, and manufacturers.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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