Closed Thread
Results 1 to 3 of 3

Make a macro not work ever, on a certain sheet

  1. #1
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Make a macro not work ever, on a certain sheet

    Hi,

    I'm using this code:
    Please Login or Register  to view this content.
    And this Works fine if I'm on the sheet "Izdaja" or "Certifikati" - the makro doesn't run.
    But if I'm on say sheet "Test" and there is a makro that copys data from sheet "test" to sheet "Izdaja" then the makro runs because the sheet "Izdaja" is not active.

    Is it some how possible to tell the makro not to work on sheet "Izdaja" EVER...if the sheet is active or not?

    BR, Denis

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Make a macro not work ever, on a certain sheet

    The code will work if sheet name is not equal to "Izdaja". so with sheet name any other will not step into the code including "Certifikati"

    if you want the code to work on the sheet only the use
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Make a macro not work ever, on a certain sheet

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    http://www.excelforum.com/showthread...t=#post4553833

    Thread Closed.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to make function only work on one sheet?
    By jamfz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2016, 12:00 PM
  2. Need help to simplify macro and make it work on same sheet again (with names?)
    By wkarotten in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2014, 05:24 AM
  3. {DELETE}Make a single sheet macro work for all sheets in workbook
    By TwistedGhost in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 04:29 PM
  4. [SOLVED] How to make the macro work for all rows in the work sheet
    By Valli nayaki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2013, 10:43 PM
  5. making a macro run automatically on start and make code work only on first sheet
    By Alheksi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-12-2010, 04:18 AM
  6. make email add forward the work sheet
    By toecutter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2005, 02:05 AM
  7. [SOLVED] Spin button in a work sheet - how do I make it work?
    By [email protected] in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2005, 04:06 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