+ Reply to Thread
Results 1 to 7 of 7

Exclude a specific sheet on onEdit function [Google Apps Script]

  1. #1
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    633

    Exclude a specific sheet on onEdit function [Google Apps Script]

    Hi Experts,

    I know this is Excel Forum but i am hoping someone could help.

    I am using this script to update the sheet name:

    Please Login or Register  to view this content.
    Question: How do I exclude a specific sheet (ex. Data Sheet) so that it won't be renamed in case I have to change the value in cell G1 of the Data Sheet?


    Thank you,
    Last edited by bhenlee; 02-10-2023 at 02:35 AM.
    If I've helped U pls click on d *Add Reputation

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

    Re: Exclude a specific sheet on onEdit function [Google Apps Script]

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    633

    Re: Exclude a specific sheet on onEdit function [Google Apps Script]

    Hi Jeff,

    Thank you for reminder. TBH i have very little knowledge with codes and I simply search for codes/script online and copy it. With little luck sometimes I'm able to edit it to suit my needs but not after searching several posts.

    I hope i made the right changes as requested.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,162

    Re: Exclude a specific sheet on onEdit function [Google Apps Script]

    Thank you, your changes are perfect. We simply ask that all members take the time to review our rules. There aren't many, and they are all important.

  5. #5
    Valued Forum Contributor
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (24 H2) 64 Bit
    Posts
    1,187

    Re: Exclude a specific sheet on onEdit function [Google Apps Script]

    Try this;

    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    633

    Re: Exclude a specific sheet on onEdit function [Google Apps Script]

    Thank you.. That did the trick!

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Exclude a specific sheet on onEdit function [Google Apps Script]

    And when you DO read the rules, also read the rule about cross-posting. You have posted the same request on at least ONE other site and not told us.

    In the even that you need further help with this question,


    NO HELP to be offered until links to ALL sites where you have cross-posted this request are provided.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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. Exclude a specific sheet on onEdit function
    By bhenlee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-09-2023, 11:21 PM
  2. need a little change in google apps script for saving data permanently
    By akshay6s in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 12-30-2021, 09:27 AM
  3. need a little change in google apps script for saving data permanently
    By akshay6s in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2021, 08:07 AM
  4. Convert VBA to Google Apps Script
    By B_H in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2021, 04:39 AM
  5. Google Sheets onEdit Script Failing On Mobile
    By swordswinger710 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 10-11-2019, 12:21 PM
  6. [SOLVED] Auto-populate a cell with a date today [Google Apps Script]
    By Kotasyon in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 10-09-2019, 04:07 AM
  7. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM

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