Results 1 to 2 of 2

Thread: How to Use same VB code in specific sheet instead of Thisworkbook

  1. #1
    Neophyte ray.kanata's Avatar
    Join Date
    Jul 2015
    Location
    Canada
    Posts
    1
    Articles
    0

    How to Use same VB code in specific sheet instead of Thisworkbook



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Thanks in advance to all for helping me out.

    Please find attached files.

    "WorkBook_A" and "WorkBook_B"

    "WorkBook_A" contains VB codes for few different functions.

    (1) Code pasted in Thisworkbook auto increment project number and clear the scoring once submitted;

    (2) Code pasted in Module 1 save file in excel & PDF formats at desktop and delete the code pasted in Thisworbook once submitted;Why delete the code in saved as file because if I don't delete the code it clears the data from saved as excel file.


    (3) Code pasted in Sheet named "Decision Point" is for populating Sheets in WorkBook_B based on selection (Yes, No, On-hold)


    Code pasted in Sheet named "Decision Point" is giving me an error.

    I need help to fix it because my knowledge of VB code is very week.

    Thanks in advance to all

    WorkBook_A.xlsmWorkBook_B.xlsx

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,537
    Articles
    0
    Excel Version
    365
    Cross posted here: http://www.ozgrid.com/forum/showthread.php?t=195820
    Anywhere else?
    Please include links to all cross posts.
    Ozgrid even has, in big letters, when you start a new thread: 4. IF YOU HAVE POSTED THE SAME QUESTIONS TO ANOTHER FORUM, PLEASE LINK TO IT IN YOUR POST.

    Here's why: http://www.excelguru.ca/content.php?184
    Read it, act on it. Ultimately to your own benefit.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •