Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Jan 2005
    Location
    Colorado Springs, Colorado, USA
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    New WorkBook - 1 Sheet (2000)

    Is it possible to open a Workbook with only 1 sheet each time, instead of 3 sheets?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New WorkBook - 1 Sheet (2000)

    How are you opening it? Are you talking about when you start Excel from the Start menu? When you do a File/New from the Excel menu? From VBA?
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: New WorkBook - 1 Sheet (2000)

    The option to set the number of sheets in new workbooks is in Tools>Options..., on the General tab.

  4. #4
    Lounger
    Join Date
    Jan 2005
    Location
    Colorado Springs, Colorado, USA
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New WorkBook - 1 Sheet (2000)

    Legare... Anytime I open it

    Tony... Will that also solve the problem when opening in VB?

  5. #5
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: New WorkBook - 1 Sheet (2000)

    New workbooks created by VBA also use this value.

    For an example function to set the number of sheets when you create a new workbook see Erlandsen Data Consulting

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New WorkBook - 1 Sheet (2000)

    If you open an existing workbook, you are going to get the number of worksheets that were in the workbook when it was last saved. If you are talking about creating a new workbook, then changing the option in Tools/Options will affect all workbooks that are created without VBA interference. That option will also affect workbooks created using VBA if the VBA code does not do anything to override it.
    Legare Coleman

  7. #7
    Lounger
    Join Date
    Jan 2005
    Location
    Colorado Springs, Colorado, USA
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New WorkBook - 1 Sheet (2000)

    Thanks you two... this seems to do the job

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •