+ Reply to Thread
Results 1 to 5 of 5

Label worksheet

  1. #1
    Registered User
    Join Date
    03-07-2019
    Location
    Santpoort Zuid, Netherlands
    MS-Off Ver
    2016
    Posts
    30

    Label worksheet

    is there a code that makes the label of the worksheet invisible? But does the worksheet remain visible?
    With the label I mean indicated in the photo with red arrowNaamloos.jpg

  2. #2
    Forum Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    266

    Re: Label worksheet

    Paste this into the ThisWorkbook Module of the workbook:


    Please Login or Register  to view this content.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Label worksheet

    Hi Toby,

    I think you are looking for the File > Options > Advanced > Display Options for this workbook > Show Sheet Tabs

    Uncheck this box and see if that is what you are trying to do.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: Label worksheet

    it is a setting that you can switch between true and false. you can find it in options > advanced > Display options for this workbook. uncheck "Sheet tabs"

    This code below is a toggleCode that will turn on or turn off sheettabs. if you link that code to a shortcutkey you can switch it on and off with that same shortcutkey

    Please Login or Register  to view this content.
    If you want to make it part of a larger code you can also add the line

    Please Login or Register  to view this content.
    to turn them off and
    Please Login or Register  to view this content.
    to turn them back on

  5. #5
    Registered User
    Join Date
    03-07-2019
    Location
    Santpoort Zuid, Netherlands
    MS-Off Ver
    2016
    Posts
    30

    Re: Label worksheet

    thanks for all the reply's, its done with de option in the menu. thanks!!!!

+ 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. [SOLVED] Link sequential worksheet cell values to userform label
    By pj2412 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2015, 09:07 AM
  2. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  3. Trying to Update Userform Label with worksheet cells
    By bmoon171 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2013, 07:59 PM
  4. Linking label of worksheet to a cell
    By ltoren in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-29-2013, 04:27 PM
  5. Replies: 5
    Last Post: 10-08-2008, 05:55 AM
  6. How can I label a worksheet based on a cell in Excel?
    By khartline in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-15-2006, 12:35 PM
  7. [SOLVED] How to take the worksheet name as a variable(Label/Define) in a fo
    By Subin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2006, 08:45 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