Closed Thread
Results 1 to 7 of 7

Help converting macro to apply to all sheets instead of active.

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Help converting macro to apply to all sheets instead of active.

    How can I make this run through all sheets?

    CODE deleted: Bypassing password
    Last edited by vlady; 09-16-2016 at 08:13 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Help converting macro to apply to all sheets instead of active.

    Your post does not comply with Rule 11 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords
    Last edited by JBeaucaire; 09-18-2016 at 01:13 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Help converting macro to apply to all sheets instead of active.

    your post does not comply with forum rule No11:
    11. Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords.
    If you are pleased with a member's answer then use the Star icon to rate it.

  4. #4
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Help converting macro to apply to all sheets instead of active.

    wow what a stupid rule. So basically, i'll post asking simply how to apply a single sheet macro to a workbook. Thanks guys, really protecting everyone with that rule.

  5. #5
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Help converting macro to apply to all sheets instead of active.

    Quote Originally Posted by taylorsm View Post
    wow what a stupid rule. So basically, i'll post asking simply how to apply a single sheet macro to a workbook. Thanks guys, really protecting everyone with that rule.
    It's less about protecting and more about not enabling. It is the right thing to do.

    How to loop through sheets has probably been answered 100s of times in this forum.

  6. #6
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Help converting macro to apply to all sheets instead of active.

    Lol. So you know that such a small request as mine is can already be easily answered but that little bump is worth the trouble. So weird how people feel the need to play mommy and daddy on what I do. It would make sense if the thing being taught had next to no value other than using for nefarious means. Like how to build a bomb or something, but cracking an old spreadsheet, whoa gotta stop that in its tracks.

  7. #7
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Help converting macro to apply to all sheets instead of active.

    Taylor, would you like the legal part of your question answered, or are you simply interested in badgering a rule that is not going to change, ever? You can certainly get what you need from our more than willing helpers, but the tone of this thread is clearly veering in a direction not in your best interest.

    On second thought, we will close this thread. You can try again in a new thread, no arguments needed there. Just ask your legal question in a clean way.
    Last edited by JBeaucaire; 09-18-2016 at 01:17 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

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] unlock sheets apply macro then lock sheets again
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2015, 10:21 PM
  2. Apply the same macro on ALL sheets
    By lab_harts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2014, 12:38 PM
  3. [SOLVED] How to apply macro on particular sheets
    By Haikal_ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2014, 09:50 AM
  4. I want to apply this macro for all sheets...How?
    By AbhijeetM in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-13-2013, 09:13 AM
  5. [SOLVED] Apply a maco to multiple active sheets
    By jbsmart in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2013, 01:42 AM
  6. Apply macro to all sheets
    By Costasg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2011, 01:09 PM
  7. Apply macro to all sheets!!!
    By Sirishgreen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-26-2007, 05:23 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