Closed Thread
Results 1 to 2 of 2

Selecting multiple sheets for a "assign-label-code"

  1. #1
    Registered User
    Join Date
    10-23-2014
    Location
    Denmark
    MS-Off Ver
    2013
    Posts
    21

    Selecting multiple sheets for a "assign-label-code"

    Hi guys,


    I have multiple excel sheets with names like:
    PG1 2013
    1. brand 2012-2013-10. brand 2012-2013 and more.

    I would like helt to one of these suggetions:

    1. Run this code on only the excel sheets that need labels to be assigned
    Or
    2. Run the code on all sheets even though far from all need a label assigned.

    Code

    Sub Tilføj_labels()
    ' Makro der tilføjer labels
    Dim x As Integer

    ActiveChart.PlotArea.Select
    ActiveChart.ApplyDataLabels AutoText:=True, LegendKey:=False, _
    HasLeaderLines:=False, ShowSeriesName:=True, ShowCategoryName:=False, _
    ShowValue:=False, ShowPercentage:=False, ShowBubbleSize:=False
    ActiveChart.ChartArea.Select
    ActiveChart.Deselect
    End Sub

    Please help me out, so I can run this code on multiple sheets or all of them.
    The code works on each individual, but since it's going to be a part of button I need it to know what sheets to be run on.

    Thank you in advance.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Selecting multiple sheets for a "assign-label-code"

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

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] Selecting multiple sheets for a "assign-label-code"
    By jakobharms in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-13-2014, 05:49 AM
  2. Replies: 3
    Last Post: 04-16-2014, 10:00 AM
  3. [SOLVED] Assign Categories for Time of Day: "Morning", "Afternoon", "Evening"
    By long_shanks in forum Excel General
    Replies: 3
    Last Post: 06-11-2013, 02:59 AM
  4. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  5. [SOLVED] scatter plots and "label" as ("X" value1, value2)
    By shabnam in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-11-2005, 10: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