+ Reply to Thread
Results 1 to 2 of 2

How to limit a code for that particular sheet ?I have the following code in Sheet 1.

  1. #1
    Forum Contributor
    Join Date
    12-11-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    308

    How to limit a code for that particular sheet ?I have the following code in Sheet 1.

    It also gets triggered when I go to other sheets and also cop/pastes on those other sheets. How can I prevent this and limit the code to run only on Sheet 1, even if I am on a different sheet (and whenever there is an input anywhere in any sheet) ? KINDLY POST YOUR ANSWER WITHIN THIS CODE so that I can simply copy and paste it. Thanks
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: How to limit a code for that particular sheet ?I have the following code in Sheet 1.

    Hello omega0010,

    I find it very strange. If you have the Code pasted in Calculate option listed in Sheet1, it should work without any problems.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ 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. VBA code to convert all data + formatting of entire sheet to VBA code
    By jocanon in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2016, 06:56 PM
  2. Re-code Userform to open range of sheets like previous sheet code
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2014, 02:31 AM
  3. [SOLVED] [VBA CODE] Password Protect a hidden sheet while using other code
    By cityinbetween in forum Excel General
    Replies: 11
    Last Post: 09-26-2014, 03:15 AM
  4. Replies: 2
    Last Post: 12-17-2013, 11:51 AM
  5. [SOLVED] find code# from sheet 1 on sheet 2, compare value on sheet 1 with value on sheet 2
    By BlakeLee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-27-2013, 01:52 PM
  6. Attach code to each sheet and if a new sheet is created add the code to this automatically
    By Irish RayRay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2012, 08:33 AM
  7. Passing variables and values between sheet code and module code
    By imux in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-14-2009, 12:23 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