+ Reply to Thread
Results 1 to 5 of 5

Help to get Macro operating efficiently

  1. #1
    Forum Contributor
    Join Date
    05-11-2006
    Posts
    104

    Help to get Macro operating efficiently

    Hi all,

    I have recorded a number of macros which are working well. However, I wold lik them to only be operational on certain worksheets within the book. For example I would like the macro to work on the sheets called Subject Leveling Y1, Subject Leveling Y2... to Subject Leveling Y6 but I would like the macro to not work on the sheet entitled Pupil Details.

    Is it possible to have the macro working in this manner and missing out certain sheets?

    Thanks for any help

    Regards

    Carl

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    At the beginning of the macro, add:
    If ActiveSheet.Name = "Pupil Details" Then Exit Sub
    Best regards,

    Ray

  3. #3
    Forum Contributor
    Join Date
    05-11-2006
    Posts
    104
    Just the sort f solutions I like - easy and quick!

    Thanks a lot for the quick response and the help - works perfectly!

    Regards

    Carl

  4. #4
    Forum Contributor
    Join Date
    05-11-2006
    Posts
    104
    As an extra thought - if I wanted to add extra sheets to the list of those where the macros should not work what would I change the coding to? Would I simply copy the code onto a new line and repeat it for the different name or is there some sort of OR command I could use?

    Thanks a lot

    Carl

  5. #5
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    Why complicate things? Add new lines.

+ 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