+ Reply to Thread
Results 1 to 2 of 2

Need a template to insert worksheet - NOT workbook

  1. #1
    Registered User
    Join Date
    01-30-2012
    Location
    cairns
    MS-Off Ver
    Excel 2003
    Posts
    29

    Need a template to insert worksheet - NOT workbook

    Hi,

    I have a workbook with different sheets for every month, when a new month starts I'd like to insert a new sheet from a template. I was hoping there'd be a way to do this without using code, is that possible? An excelforum user suggested the code below, from
    HTML Code: 
    . If this is the only way to get this done then can someone please help getting this to work in the attached workbook?

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: Need a template to insert worksheet - NOT workbook

    Quote Originally Posted by WillGe View Post
    I have a workbook with different sheets for every month, when a new month starts I'd like to insert a new sheet from a template. I was hoping there'd be a way to do this without using code, is that possible?
    Yes, this is possible. See Change the default Excel sheet template on http://www.rondebruin.nl/sheettemplate.htm
    Post responsibly. Search for excelforum.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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