+ Reply to Thread
Results 1 to 6 of 6

Create Template With 15 Worksheets That Have Blue Gridlines

  1. #1
    Registered User
    Join Date
    07-05-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    157

    Create Template With 15 Worksheets That Have Blue Gridlines

    Hello,

    I would like to create a template so when opening any new workbook it will have 15 worksheets with blue gridlines, row height of 20, column width of 10, Tahoma font, and font size 10.

    Is this possible to do?

    Thank you very much for your help,
    bj

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Create Template With 15 Worksheets That Have Blue Gridlines

    Yes it is. What is your problem ?
    Create the first sheet and copy it 14 times. Save as template

  3. #3
    Registered User
    Join Date
    07-05-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    157

    Re: Create Template With 15 Worksheets That Have Blue Gridlines

    It isn't working that way.

    I save it as a template. Then when I open a new workbook only 3 sheets show.

  4. #4
    Registered User
    Join Date
    07-05-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    157

    Re: Create Template With 15 Worksheets That Have Blue Gridlines

    I even tried to edit the template.

    File/ Options show 15 sheets but it doesn't do that.

  5. #5
    Registered User
    Join Date
    07-05-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    157

    Re: Create Template With 15 Worksheets That Have Blue Gridlines

    Hi again,

    I attached the workbook that I would like to be opened when starting Excel.

    Can this be done?

    Thanks

  6. #6
    Registered User
    Join Date
    07-05-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    157

    Re: Create Template With 15 Worksheets That Have Blue Gridlines

    I think there may be a problem where to store the file.

    I am using Windows 10 with Office 2010 where is the template folder please?

+ 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. Conditional Format to Blue Fill and Blue Font IF two conditions are met
    By Branbran10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2015, 10:52 AM
  2. create non-repeated worksheets (copy of template) with hyperlinks from main list
    By helpwanted222 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2015, 05:48 AM
  3. create worksheets and renamed based of list from other workbook into a template
    By floresp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2015, 03:32 PM
  4. [SOLVED] Create Multiple Worksheets from a template using the names in a list
    By gsemaan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2012, 02:24 AM
  5. Replies: 2
    Last Post: 02-06-2012, 07:39 PM
  6. Excel worksheets become protected out of the blue
    By Seng in forum Excel General
    Replies: 0
    Last Post: 02-22-2006, 02:47 PM
  7. Using a database to create new worksheets based from a template
    By josh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2006, 12:20 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