+ Reply to Thread
Results 1 to 3 of 3

New Workbook vs New Worksheet

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Question New Workbook vs New Worksheet

    While EXCEL (& VBA) refers to the whole file as a Workbook and the individual tabs as Worksheets. My windows right click menu prompts you to create a new "Microsoft Excel Worksheet".
    1.jpg

    Not just that, but the new Workbook created this way is named as "New Microsoft Excel Worksheet" and the 'file type' column under the windows explorer also identifies it as "Microsoft Excel Worksheet". Is this behavior universal? Can we change it (like can we define what a file type is called, or what a new file is named by default)?

    If it is universal, I find this quite inconsistent!! (Any interesting reasons/anecdotes?)

  2. #2
    Forum Contributor
    Join Date
    12-05-2015
    Location
    Akron, OH
    MS-Off Ver
    15.0
    Posts
    424

    Re: New Workbook vs New Worksheet

    It's inconsistent but I ever thought about it. I'm not sure what benefit there would be to changing it. Many programmers such as myself can be rather OCD but that inconsistency usually doesn't lead to misunderstandings since you can't create a new worksheet without first creating a new workbook. Maybe this is a bad example, but but I know my computer never literally sleeps, yet almost every day, I hit Settings --> Power --> Sleep.

    I'm guessing if you do wish to change that, you'll have to change something in the Registry.

    Post your solution if you do!
    <---If my answer helped, please click *

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: New Workbook vs New Worksheet

    I'm not much interested in changing it per se; unless it was local to my system. I do find it intriguing though.

+ 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. Replies: 5
    Last Post: 09-25-2015, 10:32 AM
  2. Transfer one worksheet in an excel workbook to another worksheet workbook
    By JASAMMY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2015, 02:50 PM
  3. Replies: 1
    Last Post: 07-19-2014, 06:28 AM
  4. Replies: 2
    Last Post: 07-16-2014, 12:36 PM
  5. Replies: 2
    Last Post: 05-01-2013, 06:17 AM
  6. Macro: Copy from one workbook worksheet to a different workbook worksheet
    By Virgil Beach in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2012, 01:13 AM
  7. Can't copy cells from Worksheet A in Workbook 1 to Worksheet B in Workbook 2
    By exartizo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2005, 05:52 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