Results 1 to 2 of 2

Thread: Button to generate new sheets based on templates

  1. #1

    Button to generate new sheets based on templates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good Afternoon (Uk Time)

    i need help in creating a button to generate new sheets based on template.

    The spreadsheets attached has for 4 tabs

    Constants
    Schedule
    Summary
    Charts

    what i need to happen is when the generate button is pressed on information page. it creates blank copies of these templates for new data to be entered.

    I need the Constants page to be copied as well but always hidden.

    There could be a problem, as vba coding that is already in the spreadsheet is linked to the tab names to make the spreadsheet work.

    Also, if i could click the button to generate a blank template it allows me to rename the new tabs to a persons name that would be great. No worries if not

    Vba project password is Kurtis2903
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    cross posted:
    http://www.excelforum.com/excel-prog...templates.html

    Kurtis2903, for your information, you should always provide links to your cross posts.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

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