+ Reply to Thread
Results 1 to 3 of 3

Workbook opens with 30 sheets

  1. 10-17-2014, 03:09 PM #1
    danishdane
    danishdane is offline
    Registered User
    Join Date
    10-17-2014
    Location
    Chicago
    MS-Off Ver
    365 ProPlus
    Posts
    2

    Angry Workbook opens with 30 sheets

    Every time I open a new workbook it automatically opens with 30 blank sheets. I can not for the life of me figure out why! Earlier I had been messing around with some macros, but there are no macros listed anywhere. Please help me out!

    Thanks!
    Reply With QuoteRegister To Reply
  2. 10-17-2014, 03:12 PM #2
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Workbook opens with 30 sheets

    Either you changed the number of default sheets - File / Options / General / When Creating new workbooks / Include this many sheets

    or your template file Book.xlt(m or x) has that many sheets and needs to be fixed.
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
  3. 10-17-2014, 03:17 PM #3
    danishdane
    danishdane is offline
    Registered User
    Join Date
    10-17-2014
    Location
    Chicago
    MS-Off Ver
    365 ProPlus
    Posts
    2

    Re: Workbook opens with 30 sheets

    Wow...I feel extremely stupid...that was it. I just spent like half an hour trying to figure it out. It's been a long day..

    THANK YOU!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how can i execute a macro in current workbook after another workbook opens?
    By sds1126 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2014, 09:36 AM
  2. Macro; open workbook 1, then workbook automatically opens?
    By lukasj13 in forum Excel General
    Replies: 3
    Last Post: 07-12-2014, 06:04 AM
  3. macro that copies information from a worksheet from workbook A then opens a new workbook a
    By starlev in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2014, 05:20 AM
  4. 2003 opens new sheet, 2010 opens new workbook
    By AllTheGearNoIdea in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2011, 10:29 AM
  5. Personal workbook opens when Excel opens
    By SheriTingle in forum Excel General
    Replies: 3
    Last Post: 03-29-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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1