+ Reply to Thread
Results 1 to 2 of 2

Microsoft Excel Objects (two different worksheet types)

  1. #1
    Registered User
    Join Date
    01-05-2017
    Location
    Frankfurt, Germanyyy
    MS-Off Ver
    2010
    Posts
    5

    Microsoft Excel Objects (two different worksheet types)

    Hi there, I see two different types of worksheet objects.

    See the attached pic. I tried to change the "names" of the worksheets that start with "Sheet6" but couldn't. I could only change the name that appreas in brackets.
    Thanks a lot!
    Tom

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Microsoft Excel Objects (two different worksheet types)

    There are 2 worksheet 'names'. One is the Tab name (as appears on the sheet tab) and the other is the Code name.

    The Tab name can be changed by code, the code name cannot. It can only be changed manually in the Properties Window for the worksheet.

    Guessing. There is no attachment to view your issue.

+ 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] Microsoft Scripting Library: Declaring file (variables/objects?): Is it an object or var.?
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-04-2016, 06:26 PM
  2. How do you delete Microsoft Excel Sheet Objects???
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2014, 11:20 AM
  3. Microsoft ActiveX Data Objects 2.9 Library
    By timdecker in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-20-2014, 02:55 PM
  4. [SOLVED] How to rename Microsoft Office Drawing Objects :D
    By LaffyAffy13 in forum Excel General
    Replies: 1
    Last Post: 07-25-2013, 04:26 PM
  5. Microsoft Linked Objects - Relative Paths
    By borat in forum Excel General
    Replies: 0
    Last Post: 07-26-2007, 08:26 AM
  6. Making Microsoft Graph objects invisible
    By TonyV in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2005, 06:05 PM
  7. Replies: 1
    Last Post: 05-12-2005, 08: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